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
Good news everyone! The Boards.ie Subscription service is live. See here: https://subscriptions.boards.ie/

Simple Excel question - plot onto one graph

  • 03-03-2014 06:27PM
    #1
    Registered Users, Registered Users 2 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

  • Registered Users, Registered Users 2 Posts: 3,837 ✭✭✭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


  • Registered Users, Registered Users 2 Posts: 434 ✭✭Smythe


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


  • Registered Users, Registered Users 2 Posts: 3,837 ✭✭✭dmc17


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

    Most welcome.


Advertisement