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
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Simple Excel question - plot onto one graph

  • 03-03-2014 5:27pm
    #1
    Smythe
    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

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


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


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


  • #4
    dmc17
    Registered Users, Registered Users 2 Posts: 3,782 ✭✭✭dmc17


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

    Most welcome.


Advertisement