+ Reply to Thread
Results 1 to 3 of 3

Issues with the scale of a graph

  1. #1
    Registered User
    Join Date
    06-24-2009
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    6

    Issues with the scale of a graph

    Here's the problem, I am plotting two different Y values that have the same X value; however instead of having a scale for my X axis (for example, each line on my x axis represents an increase of 5) I want the X axis to to representative of my data. So instead of having the values of X axis increase by a set increment, the X-Axis scale will represent the values I am plotting.

    I have attached a copy of my graph, as you can see the scale is set to increase by 14; but I want to disregard that and have it so the first value of the scale is April 01/09, the second is Apr 06/09, the third May 01/09 etc... all the way up to the final value, Jan 02/10.

    Thanks for the help
    Attached Files Attached Files
    Last edited by dante19; 11-04-2009 at 03:41 PM.

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Issues with the scale of a graph

    Hi dante19,

    Right click on your chart, select "Chart Options", view the "Axes" tab, and select "Category" for your "Category (X) axis" option.

    Cheers,

  3. #3
    Registered User
    Join Date
    06-24-2009
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Issues with the scale of a graph

    Thanks Connexion, problem solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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