Remove shading from a surface chart in Excel 2007

Question

I have a data set that is fairly noisy and I find that the lighting and shading that is applied to the chart is distracting me from seeing the general contours of the data. Is there a way to turn off the lighting/shading so that there is a solid color for data within a band?

Answer 1

To remove the shading on surface charts requires a bit of code as there is no UI.

Select the chart. ALT+F11 to open VBE. CTRL+G to open immediate window. Enter following command and press Enter.

activechart.ChartGroups(1).has3dshading=false

---

Cheers,

Andywww.andypope.info

Answer 2

Try this:-

Click in the Chart.

Chart Tools.

Design contextual tab.

Chart Styles group.

Click on Style 2 (because this is pretty, “solid”).

If my comments have helped please Vote As Helpful.

Thanks.

Answer 3

I actually have already chosen Style 19 as the best of the possible styles but I still have a problem with chart appearance. It is plotted as if there is a light in the upper right and the lower left side of every feature is lost in shadow.

Answer 4

Sorry 2 not 19; my mistake. " 2 is much clearer and more, "solid".

Answer 5

Thanks Andy,

That did the trick but I am surprised that it isn't part of the user interface.

I will have to save the command someplace for later use.

-David