3d shading

[Suzanne]

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!

 

[Christopher Scott [MSFT]]

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.

 

[Jon Peltier]

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
_______

 

[Suzanne]

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]

Suzanne:

You probably do have this option, but it is not so easy to find. It took me
five minutes. I don't think the trial version has any fewer features than
the full version, only a time limit.

Right click legend entry, choose Format Band, click on the 3D Format item on
the left of the dialog, and click the Material dropdown button. You will see
a screen tip when you move the mouse over the icons. The third one in the
second row is "Flat".

Christopher:

If you're still reading, have the programmers include the labels under the
icons, rather than as screen tips. If users have to wait for the screen tip
to appear in order to know what something is called, it's going to take them
longer to do anything, and they will feel that the marketing claims about
this interface's productivity will be even more overexaggerated.

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