Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Melbourne, Fl USA
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Secondary Axis (Excel 2003 SP1)

    I have a chart that has 2 secondary axis' - see attached. I know it makes the chart a bit busy, but my boss has asked me to add a third secondary axis. The data for the new axis is on row 47. I've tried everything I can think of; but when I try to add that line of data to the existing chart, not only does it not show the 3rd line of data, it also messes up the existing secondary data that is plotted from row 38. Is there a limit of 2 secondary axis'? If not, can someone show me how to add a 3rd? I know if this can be done, my boss will want the same type of info on other charts. Thanks in advance.

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

    Re: Secondary Axis (Excel 2003 SP1)

    You don't have two secondary axes, you have a primary axis (for the column series) and a secondary axis (for the line charts). That's it, there is no tertiary axis.
    The best you can do is plot the new series on the secondary axis and change the Maximum Scale for this axis, so that the new series is visible within the plot area. See attached version.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Secondary Axis (Excel 2003 SP1)

    <hr>I've tried everything I can think of; but when I try to add that line of data to the existing chart, not only does it not show the 3rd line of data, it also messes up the existing secondary data that is plotted from row 38.<hr>

    The line was being added to your chart when you drag it on, but because there was such a large difference in the % values, the 3rd line did not display as it was outside the markers range on the chart. It is just a matter of readjusting the marker values on the secondary axis sothat the axis can display values below 70%.
    Regards,
    Rudi

  4. #4
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Melbourne, Fl USA
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thank you

    Now I understand. Thanks Hans.

  5. #5
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Melbourne, Fl USA
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thanks

    Thanks to you too, Rudi. I get it now.

Posting Permissions

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