can any one help me in changing the legend scale of the surface chart in
Excel 2007, there used to be an option in the format legend dialog for Excel
2003 but here i could not find it but i have to increase the number of
contours in the plot

help me please

Hi,

You need to use the Vertical (Value) axis dialog.
To get this you can select the chart and then select the Format contextual
tab.
In the Current Selection group use the dropdown list to select Vertical
(value) axis. Press F1 if the format dialog is not currently displayed.

One thing I did discover is that if you use the up arrow to cycle through
selected chart elements it does not go through Vertical value axis.
But if you use the Down arrow it does.

One other thing I noticed is the order of bands is reversed to that of
xl2003.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"ramki" wrote in message
...
can any one help me in changing the legend scale of the surface chart in
Excel 2007, there used to be an option in the format legend dialog for
Excel
2003 but here i could not find it but i have to increase the number of
contours in the plot

help me please

hi thank you Andy i got it...
thank you very much

"Andy Pope" wrote:

Hi,

You need to use the Vertical (Value) axis dialog.
To get this you can select the chart and then select the Format contextual
tab.
In the Current Selection group use the dropdown list to select Vertical
(value) axis. Press F1 if the format dialog is not currently displayed.

One thing I did discover is that if you use the up arrow to cycle through
selected chart elements it does not go through Vertical value axis.
But if you use the Down arrow it does.

One other thing I noticed is the order of bands is reversed to that of
xl2003.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"ramki" wrote in message
...
can any one help me in changing the legend scale of the surface chart in
Excel 2007, there used to be an option in the format legend dialog for
Excel
2003 but here i could not find it but i have to increase the number of
contours in the plot

help me please

Sure, I can help you with that! In Excel 2007, you can change the legend scale of a surface chart by following these steps:

1. Click on the surface chart to select it.
2. Click on the "Chart Tools" tab in the ribbon.
3. Click on the "Format" tab within the "Chart Tools" tab.
4. In the "Current Selection" group, click on the "Chart Elements" dropdown menu and select "Legend".
5. Right-click on the legend and select "Format Legend".
6. In the "Format Legend" dialog box, click on the "Number" tab.
7. In the "Category" list, select "Scale".
8. In the "Minimum", "Maximum", and "Major unit" boxes, enter the values you want to use for the legend scale.
9. Click "OK" to apply the changes.

To increase the number of contours in the plot, you can adjust the settings for the chart's data series. Here's how:

1. Click on the surface chart to select it.
2. Click on the "Chart Tools" tab in the ribbon.
3. Click on the "Select Data" button in the "Data" group.
4. In the "Select Data Source" dialog box, select the data series you want to modify and click the "Edit" button.
5. In the "Edit Series" dialog box, adjust the settings for the "Series X values", "Series Y values", and "Series Z values" as needed.
6. To increase the number of contours, you can try increasing the number of data points in the "Series X values" and "Series Y values" fields.
7. Click "OK" to apply the changes.