Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: adding more info to x-axis of chart

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a line chart that shows time (x-axis) vs. money (y-axis). The time axis shows months numbered from 1 to 60. I would like to add some kind of title or text field below the x-axis that shows that months 1 to 12 are year 2002, months 13 to 24 are year 2003, etc. I tried using a text box but although it looks good on the screen, it is skewed when printed.

    Any ideas on how to do this?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    In a column to the left on of your month numbers enter 2002 adjacent to the cell containing 1, 2003 adjacent to cell contains 13, etc.

    After selecting your chart choose the Chart | Source Data... menu command. On the Series tab enter the cell range for the above values (e.g., A1:B60) in the "Category (X) axis labels:" field.

  3. #3
    New Member
    Join Date
    May 2002
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for the help! I was able to do as you said, but by doing so the axis changes. Instead of showing labels on every month, it now shows labels on every 4 months. I'll play around with it and figure something out. It should be easier now that I know how to do it.

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-09 05:55, phillycarol wrote:
    Thanks for the help! I was able to do as you said, but by doing so the axis changes. Instead of showing labels on every month, it now shows labels on every 4 months. I'll play around with it and figure something out. It should be easier now that I know how to do it.
    You might need to reduce your font size to get the desired effect.

  5. #5
    Board Regular
    Join Date
    Apr 2007
    Location
    Mount Annan, Australia
    Posts
    60
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: adding more info to x-axis of chart

    This tip is still relevant in 2013. I like the effect I got under the current versionof Excel.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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