Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Feb 2003
    Location
    Bend, Oregon
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Charting Problem (Excel 2002 SP3)

    A sample spreadsheet and chart are attached which show this issue:

    I have a dynamic chart which uses a style of

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

    Re: Charting Problem (Excel 2002 SP3)

    You can do this by adding dummy series (with blank values) plotted as column charts; I added one for the primary axis and one for the secondary axis, then deleted their entries in the legend. If you select Chart | Source Data, Series tab, you will see how they have been defined.

  3. #3
    Star Lounger
    Join Date
    Feb 2003
    Location
    Bend, Oregon
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Charting Problem (Excel 2002 SP3)

    Thanks Hans,

    It worked perfectly. I just wanted to make sure I understood why it works. Am I correct in believing that it is because the percentage series overlays the dummy series linked to the numeric axis and the numeric series overlays the dummy series linked to the percentage axis?

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

    Re: Charting Problem (Excel 2002 SP3)

    Yes, that's it. I forgot to mention that I changed the order of the series for one of the axes, resulting in the effect you mention.

  5. #5
    Star Lounger
    Join Date
    Feb 2003
    Location
    Bend, Oregon
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Charting Problem (Excel 2002 SP3)

    Thanks again Hans,

    I love learning new tricks. <img src=/S/clever.gif border=0 alt=clever width=15 height=15>

Posting Permissions

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