Excel 2007: Contour map (surface map)

Hi

I have made a surface map using the contour map chart type. Thing is i
cannot work out how to adjust the legend bands. For example:

i have 3 bands

0-1000 Red
1000-2000 Blue
2000+ Green

but say if i wanted to add a 4th band or increase the number of bands in the
0-2000 range to 4 then how would i do that?

thanks

Sam

You need to format the vertical value axis. You can't see it in the chart,
so you have to select it using the dropdown in the top left of the Chart
Tools Layout or Format tabs. Then you can't tell it's selected, but it is,
so press Ctrl+1 (numeral one) to bring up the Format Axis dialog, and set
your axis scale parameters. The fill formatting changes for each major axis
division.

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


"Sam" wrote in message
...
Hi

I have made a surface map using the contour map chart type. Thing is i
cannot work out how to adjust the legend bands. For example:

i have 3 bands

0-1000 Red
1000-2000 Blue
2000+ Green

but say if i wanted to add a 4th band or increase the number of bands in
the
0-2000 range to 4 then how would i do that?

thanks

Sam