Hi Jon
I do not have a "Flat" option on the 3D format tab. Is it possible because I
am running a trial version? I don't want to purchase this new XL if I can't
get the 3D shading to turn off. I really hate to go back to XL2003, but if I
can't get this resolved, I guess I'll have to. It's really driving me crazy!

"Jon Peltier" wrote:

Alternatively, you can format each legend entry (band), and apply the
"Flat"
material on the 3-D Format tab.

I'm glad to see this. Too bad it can't be applied to the entire chart at one
time.

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


"Christopher Scott [MSFT]" wrote in
message ...
You can run the following in VBA (Alt+F11, then Ctrl+G):
ActiveChart.ChartGroups(1).Has3DShading = False

Alternatively, you can format each legend entry (band), and apply the
"Flat"
material on the 3-D Format tab.

You can then save this as a new template for future charts.

--
Thanks,
Christopher

This posting is provided "AS IS" with no warranties, and confers no
rights.


"Suzanne" wrote:

I have the newest version of excel (trial version), how do you turn off
the
3d shading in a surface chart? I have searched and searched and cannot
find
any answers or functions to do so. I need to make plain ol' gradient
surface
charts, but they all automatically have 3d shading. Help!