Turn on thread page Beta
    • Thread Starter
    Offline

    18
    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:
    TSR Support Team
    (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

    18
    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:
 
 
 
Poll
Do you think parents should charge rent?

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

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