XL2007 surface chart tesselation
 

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.

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.

XL2007 surface chart tesselation
 

This is an example of how the new Excel formats are nice, except when
they're not. I've spent a half hour on this, and I can't figure out how to
get away from the oblique lighting effect. I also found the new interface
for surface/contour charts difficult to use to get the orientation and
perspective I wanted.

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


"rossu" wrote in message
...
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.

XL2007 surface chart tesselation
 

Not available in the UI? Then I guess there's room for it in an Excel 2007
Charting add-in :-)

- 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

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.

XL2007 surface chart tesselation
 

I'm having the same problem...we both got a response from christopher, I
tried his suggestion, but it does not work...has it for you?

"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.

XL2007 surface chart tesselation
 

Well, I got in this morning and fired up XL ready to Chris's suggestion and
lo and behold all the tessaltion was gone from my graphs. Presumably in my
ramblings yesterday I had shut off the necessary bit. The only difference
between today and yesterday is that I shut down XL when I went home (and I
had the problem) and I fired it up this morning. I have no idea, what
actually fixed the problem and I haven't tried Chris's fix. I have found two
nasty bugs though that I'm about to post.

I'ld sure like to know the answer to this one though, a I'm sureI'm going to
want to do more of this kind of graph.

"Suzanne" wrote:

I'm having the same problem...we both got a response from christopher, I
tried his suggestion, but it does not work...has it for you?

"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.

XL2007 surface chart tesselation
 

I finally figured out how I made the shading go away. I saved it as an xls
file instead of an xlsx file. When you reload it, the tessalation and
triangles are gone.

"Suzanne" wrote:

I'm having the same problem...we both got a response from christopher, I
tried his suggestion, but it does not work...has it for you?

"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.