2007: Legend format in Surface plots / shadow effect
 

Me again, for another "bug" in version 2007.

With previous versions, when you created a surface plot, the format of the
legend numbers was based on the format of the number behind the grid. Very
convenient. This is not the case anymore. I discovered that on a grid based
on %. Now I have 1 for the max, instead of 100%

Another thing is that the frontiers between two colors are not ugly (strange
colors - or strange 3D/shadow effect). It used to be a lot cleaner with
previous versions.

MrT

Legend format in Surface plots / shadow effect
 

The coloring is a matter of taste, I guess. The new surface charts have
shading, not just flat colors, for the different value ranges. The shading
seems to be related to illumination coming from some angle, though there's
no way to control this angle or the degree of shading.

I noticed a problem with contour charts while checking this out. The labels
across the bottom axis of the chart are not constrained by the chart area,
but may be cut off because Excel draws them too low to fit in the chart.

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


"MrT" wrote in message
...
Me again, for another "bug" in version 2007.

With previous versions, when you created a surface plot, the format of the
legend numbers was based on the format of the number behind the grid. Very
convenient. This is not the case anymore. I discovered that on a grid
based
on %. Now I have 1 for the max, instead of 100%

Another thing is that the frontiers between two colors are not ugly
(strange
colors - or strange 3D/shadow effect). It used to be a lot cleaner with
previous versions.

MrT

Legend format in Surface plots / shadow effect
 

Hi Jon,

Thanks for checking my various remarks. I hope this will be read by someone
from the dev team of Excel.

"Jon Peltier" wrote:
The coloring is a matter of taste, I guess. The new surface charts have
shading, not just flat colors, for the different value ranges. The shading
seems to be related to illumination coming from some angle, though there's
no way to control this angle or the degree of shading.

I think a surface plot has be a surface plot. The shading effects are not
compatible with the expectations of scientists (which I am).

I noticed a problem with contour charts while checking this out. The labels
across the bottom axis of the chart are not constrained by the chart area,
but may be cut off because Excel draws them too low to fit in the chart.

I checked this and confirm it too.

Cheers,

MrT