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

Excel Graph Question

  • 22-04-2011 4:22pm
    #1
    Dubsey
    Registered Users, Registered Users 2 Posts: 174 ✭✭


    Hi all,

    Hoping that someone can help me:

    I have two sets of data that I want to show on a line graph in Excel. I want to show both sets of data on the same X-axis but the graph that I am using only seems to allow me to use one set of X-axis points.

    As an example, one set of data would be:
    X Series 1 1 1 5 2 10 3 15 4 44 5 67 6 80 7 85 8 100 9
    While the other could be:
    X Series 2 3 11 20 12 21 13 38 14 55 15 100 16
    Thanks for any help!


Comments

  • #2
    Dubsey
    Registered Users, Registered Users 2 Posts: 174 ✭✭Dubsey


    OK - the data doesn't look the same when posted.

    Hopefully you get my drift.


  • #3
    Snowbat
    Registered Users, Registered Users 2 Posts: 1,065 ✭✭✭Snowbat


    Like this?
    156256.png


  • #4
    kellogskelly
    Registered Users, Registered Users 2 Posts: 27 ✭kellogskelly


    Hi, I will to plot a line graph of year vs. sales on excel 2010. However, the years are displaying on the y-axis wihile nothing but 1,2,3 etc is displaying on the x-axis.... Anybody might know what the problem is?


  • #5
    yoyo
    Moderators, Technology & Internet Moderators Posts: 11,017 Mod ✭✭✭✭yoyo


    kellogskelly wrote: »
    Hi, I will to plot a line graph of year vs. sales on excel 2010. However, the years are displaying on the y-axis wihile nothing but 1,2,3 etc is displaying on the x-axis.... Anybody might know what the problem is?

    Are you sure you highlighted all the data when building the graph?

    Nick

    My Beer Glass collection site 🍺

    My Irish Callcards site



Advertisement