how change the legend scale of surface chart in XL2007

R

ramki

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
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bar Chart in Excel 2010 does not display neither Horizontal axis labels, nor legend 0
Changing/Manipulating Legend range for a Pivot Chart in XL2010 vsXL2003 and below. 0
Change symbols in a Network Diagram legend. 0
Surface Chart/Contour Chart options 4
changing the name in the legend 2
Doughnut Chart linked with the slicer in the pivot table 0
Legend Overlaps Chart in Excel 2007 4
Change order of items in a legend 1

Top