Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Posts
    122
    Thanks
    7
    Thanked 0 Times in 0 Posts

    Stacked Bar Chart Display Problem (2003)

    I noticed that the bars on a stacked bar chart with 3 or more segments do not align with the Y axis scale, e.g. on the attached sample chart Bar A is 14,000 units but as displayed appears to be less that 14,000 units high. Is this a known problem wit Excel? I did not find any references on the MS Knowledgebase.

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

    Re: Stacked Bar Chart Display Problem (2003)

    It's a matter of perspective. The 3D columns are standing in front of the rear wall of the chart, not up against it. Since you are looking at the chart from above, to the fore = lower. If you select Chart | 3-D View and set Elevation to 0, you'll see that the heights are correct.

    This is a good reason why 3-D charts should in general be avoided. They may look spiffy, but they are hard to interpret correctly.

Posting Permissions

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