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/
_______


EPratt wrote:

> 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?

Thank you so much Jon! That was exactly it.

"Jon Peltier" wrote:

> 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 wrote:
>
> > 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?
>

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

"Jon Peltier" wrote:

> 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 wrote:
>
> > 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 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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"RM" <(E-Mail Removed)> wrote in message
news:F78BB1EA-DA60-4E13-BC91-(E-Mail Removed)...
> Microsoft should consider setting the gap depth to 0 as the default for 3D
> view charts.
>
> "Jon Peltier" wrote:
>
>> 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 wrote:
>>
>> > 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?
>>