Z-Axis Scale Adjustment for Contour Plots

[Randy]

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?

 

[Jon Peltier]

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

 

[Randy]

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

 

[Christopher Scott [MSFT]]

The 97-2003 file format is a good find. You can also turn the 3-D effect for
a chart all at once through automation by running in Visual Basic:
ActiveChart.ChartGroups(1).Has3dShading = False

 

[Jon Peltier]

Nice. I was assuming I'd have to loop through the series collection to
format the series individually.

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

 

[EL]

Hi, your post were quite helpful. Thanks

I have another problem, I would like to change the x axis labelling. Now in
my case i am changing a parameter c from 1 to 2 in intervals of 0.1 in the
series data, I would like that the labeling in the x axis is 1, 1.1, 1.2,
1.3...etc. I tried from the format axis but only whole numbers are allowed
(interval between tick marks/ specify interval unit). Is there a way to go
about this?


I have a similiar problem with the y axis - on the y axis i am changing a
parameter d from 1 to 2 again. The axis labeling is series 1, series 2,..
etc. Now i would like to change it to 1, 1.1, 1.2 ..etc. I guess I have to
change each series name manually from the select data tab.

Thanks a lot