Excel 2007: Contour map (surface map)

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

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
 
Back
Top