Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Simple Excel question - plot onto one graph

Options
  • 03-03-2014 6:27pm
    #1
    Smythe
    Registered Users Posts: 434 ✭✭


    On the attached Excel sheet I want to place all the values shown onto one graph which should show on it six different curves.

    The numbers in red are the horizontal x-axis, and the black numbers for the vertical y-axis.

    Would anyone know how to go about this? Thanks!


Comments

  • Options
    #2
    dmc17
    Registered Users Posts: 3,746 ✭✭✭dmc17


    Is it something like what I've attached? If so:
    • Use the first set of x & y values to create a scatter graph.
    • Click the chart, go to design tab and click 'Select Data'.
    • Add the 5 other ranges by clicking add series on the left of this dialog box
    • Click change chart type and change to scatter with lines


  • Options
    #3
    Smythe
    Registered Users Posts: 434 ✭✭Smythe


    Yes, that's it. Thanks very much for that dmc17, and for the explanation!


  • Options
    #4
    dmc17
    Registered Users Posts: 3,746 ✭✭✭dmc17


    Smythe wrote: »
    Yes, that's it. Thanks very much for that dmc17, and for the explanation!

    Most welcome.


Advertisement