View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Christopher Scott [MSFT] Christopher Scott [MSFT] is offline
external usenet poster
 
Posts: 27
Default 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.