3d bar chart gridlines

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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/
_______
 
Thank you so much Jon! That was exactly it.

Jon Peltier said:
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/
_______
Click to expand...
 
Microsoft should consider setting the gap depth to 0 as the default for 3D
view charts.
 
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
 
Back
Top