Thanks Jon!

Who would have guessed that the Y-axis is elevation on a contour plot?!

I also found that if I saved the file in 2003 format the 3D shading went
away. Still used a bad color selection for depicting the data but it is at
least a quick way to get them all to change at once.

Randy

"Jon Peltier" wrote:

How do you set the contour plot z-axis legend scale in 2007?

Activate the Layout or Format tab, and choose the Vertical (Value) Axis from
the dropdown in the top left of the ribbon. (Yes, it's there even though
it's a flat contour chart). Press CTRL+1 (numeral one) to open the Format
Axis dialog, and adjust the scale here.

is there a way to get rid of the 3-D look of 2007?

Don't you hate that? It's absolutely miserable. This is a royal pain to fix.
You have to do this for each series:

Select the corresponding legend entry for the series, and press CTRL+1 to
format it. Select 3D Format from the items on the left edge of the dialog,
then under Surface Material, choose Flat (third one in the Special Effect
row).

Ironic that Flat is a special effect.

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


"Randy" wrote in message
...
How do you set the contour plot z-axis legend scale in 2007? In 2003 I
could
double click on the legend and then select the bottom point, range between
points and top point of the z-axis scale. Also, is there a way to get rid
of
the 3-D look of 2007 and go back to the 2003 countour plot look with
flat/uniform colors for a given range of data?