Bar Charts

[Rawle]

When I make a 3D bar chart I cannot get the bars to reach to the horizontal
line that refle cts the value. For example I have a value of 100,000 and the
bar has a value horizontal line of 100,000 but the bar on the chart stops
short of 100,000 line. I know there is a way to adjust it but cannot
remember how it is done. Please help.

 

[Jon Peltier]

Use a 2D chart. You won't get the funky effects that a marketing guy likes
to show off his slides and obscure his data. Instead you'll get a clear and
simple chart that avoids the distortion caused by false perspectives and
avoids the clutter required to display a data point as a false 3D block
rather than as a simple flat rectangle.

- Jon

 

[Rawle]

Thanks but I think I recall making the adjustment in a 3D chart so that the
bar reads correctly off the horizontal line. It mayhave been in Excel 2003.

 

[Andy Pope]

Hi,

The setting is probably Gap depth of the series.
But I also would *strongly* recommend using 2d charts.

Cheers
Andy