Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multi-axes chart (XP)

    Hi - a co-worker needs to chart the info in the attached document. I chose columns and lines on 2 axes and it works pretty well - any better suggestions?

    Thanks, again . . .

    Aunt Linda

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multi-axes chart (XP)

    The chart in itself seems fine to me, but the numbers along the vertical axes take up a lot of space. You might modify the number format for these axes to display the amounts in millions of dollars, for example 0.0,, to display only numbers, or $0.0,,M to include a dollar sign and M for million. And you might use the axis titles (in Chart Options) to indicate which data correspond to each axis.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multi-axes chart (XP)

    Thanks Hans - I did tell her to spend some time refining the looks of the thing - I just wanted to know if there was another chart option maybe I didn't know about.

    Have a terrific day

    Aunt Linda

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Multi-axes chart (XP)

    Personally, I am not crazy about the 2 axes with the 4 ranges. It is difficult to tell which items go with which axis.

    Since you are making a separation between the 2 sets of data, I see no reason to plot onto one chart. I would just create 2 charts each with 1 axis or put all the data with only 1 axis to show the relative sizes of all of them if you need to compare all 4.

    Steve

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Chicago, Illinois, USA
    Posts
    187
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Re: Multi-axes chart (XP)

    I agree with Steve, but if you are still wanting to go with a two axis chart, check out this format. The intent here is to make it easier to interpret the data as charted.

  6. #6
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Chicago, Illinois, USA
    Posts
    187
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Re: Multi-axes chart (XP)

    Although, I would personally prefer this format.

Posting Permissions

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