3d bar chart gridlines

[EPratt]

I created some 3d stacked column charts and the back of the 3d columns don't
line up exactly with the gridlines. Any way to fix this?

 

[Jon Peltier]

They don't line up because there's a gap between the bars and the back
of the chart. You can fix this by double clicking on a series, and on
the Options tab, change Gap Depth to zero. You can make the chart even
more clear to your poor audience if you switch to a 2D chart type.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[EPratt]

Thank you so much Jon! That was exactly it.

They don't line up because there's a gap between the bars and the back
of the chart. You can fix this by double clicking on a series, and on
the Options tab, change Gap Depth to zero. You can make the chart even
more clear to your poor audience if you switch to a 2D chart type.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[RM]

Microsoft should consider setting the gap depth to 0 as the default for 3D
view charts.

 

[Jon Peltier]

They should really consider dropping those lame 3D charts, but they have too
many corporate marketing bozos among their customers, and not enough
scientists. What does an oblique view of a pseudo-3D block tell you that a
straight on view of a rectangle doesn't?

- Jon