XL2007 surface chart tesselation
You can run the following in VBA (Alt+F11, then Ctrl+G):
ActiveChart.ChartGroups(1).Has3DShading = False
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.
"rossu" wrote:
When I create a flat contour chart, XL insists on making all the areas
teselated surfaces so that I get shadowing of the areas instead of a steady
single colour. I want to turn this off and get a single colour for each
contour level (like all the XLs before 2007). I can't figure out how to do
this. Can someone help me.
|