Excel 2007: Contour map (surface map)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sam - 14 Apr 2008 12:21 GMT

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

Reply to this Message

Jon Peltier - 14 Apr 2008 12:50 GMT

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
_______

> Hi
>
[quoted text clipped - 14 lines]
>
> Sam

Reply to this Message