Hey there! Sign in to join this conversationNew here? Join for free
    • Thread Starter
    Offline

    16
    ReputationRep:
    I feel like such a grandma asking this, I already tried Google and didn't get it, I actually used to be such a whizz with excel I'll have you know! :shakecane:

    Basically I'm trying to plot a graph with the y axis as Refractive Index, and the x axis as XA

    This is my data, and how the graph keeps showing up which is exactly what I don't want :confused:


    Any help would be much obliged considering I have 4 other graphs to make for this lab report :lol:
    • TSR Support Team
    Offline

    20
    ReputationRep:
    (Original post by KaylaB)
    I feel like such a grandma asking this, I already tried Google and didn't get it, I actually used to be such a whizz with excel I'll have you know! :shakecane:

    Basically I'm trying to plot a graph with the y axis as Refractive Index, and the x axis as XA

    This is my data, and how the graph keeps showing up which is exactly what I don't want :confused:


    Any help would be much obliged considering I have 4 other graphs to make for this lab report :lol:
    Right click on the graph and hit select data. There you will be able to add a data series (i.e. a line on the graph that represents your data) and a select the values for your other axis.
    • Thread Starter
    Offline

    16
    ReputationRep:
    (Original post by Smack)
    Right click on the graph and hit select data. There you will be able to add a data series (i.e. a line on the graph that represents your data) and a select the values for your other axis.
    Ace cheers! :thumbsup: I seem to have just messed around with the settings there and it's worked!

    My question is, is there any way of telling the graph to input it like this from the start, like when you're selecting data, as opposed to meddling around in the settings after it shows up as 2 lines instead of 1. I feel like there was a far simpler way of doing this :hmmmm:
 
 
 
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • Poll
    What newspaper do you read/prefer?
    Useful resources

    Articles:

    The Student Room tech wikiTech forum guidelines

    Quick link:

    Unanswered technology and computers threads

    Sponsored features:

    Web Legend

    Win a Macbook Air!

    Blog about setting up a website for a chance to win in our Web Legend competition.

    Groups associated with this forum:

    View associated groups
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

    Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

    Quick reply
    Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.