|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 18th, 2007, 11:16 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
how change the legend scale of surface chart in XL2007
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 
|
|
#2
July 19th, 2007, 10:12 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
how change the legend scale of surface chart in XL2007
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
|
|
#3
July 19th, 2007, 10:34 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
how change the legend scale of surface chart in XL2007
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
