+ Reply to Thread
Results 1 to 3 of 3

Unable to graph the desire x values on line graph..?

  1. #1
    Registered User
    Join Date
    04-24-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Unable to graph the desire x values on line graph..?

    Hey there,

    I've been trying and trying to simply graph my two columns A and B on a line graph. I cannot get the x-axis values to appear correctly though. I'm sure there's a simple way of fixing this. Please help! I've got 4 lots of graphs I need to create in the same manner.

    The graph in the excel document is just as I'd like to have it. However, I would like column B along the x, horizontal axis.

    Cheers,
    Tigertan
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    04-24-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Unable to graph the desire x values on line graph..?

    Any ideas?

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,097

    Re: Unable to graph the desire x values on line graph..?

    Excel expects the first column to be the X values subsequent columns the Y values for a series.

    Simply change the layout of you data and help Excel further by adding a series name to your data.

    If you really do not want to change the data layout then use the Select Data dialog to define series and the ranges to use.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1