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