#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default contour interval

Really now.... How do you change the contour interval of a contour surface
chart in Excel 2007? In previous versions, all that was required was a
simple right click on the legend, a click on format, and a change of the
scale. Where is this function in 2007? Why does such a simple, common
problem not have any coverage in the help files? Does everyone who makes a
surface map accept the default contour intervals? Are we all just sheep? Or
am I the first one to try this?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default contour interval

Hi,

If the surface chart is of the 3d type you can select the vertical axis and
adjust the Major Unit.

If the 2d type is being used the selection process is more subtle due to
bug/feature in the chart.
Select the chart and display the Format dialog. As the dialogs are now
modaless you can set focus back to the chart and the dialog will update with
the current select.
So use the cursor DOWN arrow to cycle through the chart elements. Using the
DOWN key appears to reveal more selectable items than the UP cursor.
Anyway by moving through the chart elements in this way you can get to the
vertical axis and adjust the Major Unit value.

You can then use the legend items to format the bands.

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Really now..." <Really wrote in message
...
Really now.... How do you change the contour interval of a contour surface
chart in Excel 2007? In previous versions, all that was required was a
simple right click on the legend, a click on format, and a change of the
scale. Where is this function in 2007? Why does such a simple, common
problem not have any coverage in the help files? Does everyone who makes
a
surface map accept the default contour intervals? Are we all just sheep?
Or
am I the first one to try this?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Contour Plot Grids Matt Charts and Charting in Excel 4 October 10th 07 06:43 PM
chart gets BIG contour when pasted in Word Texas Tonie[_2_] Excel Discussion (Misc queries) 0 July 25th 07 11:16 PM
contour plots JohnC Charts and Charting in Excel 1 May 23rd 05 01:12 PM
contour plot in 3D graph mtwilfer Charts and Charting in Excel 3 May 9th 05 08:12 PM
Contour plot ojv Charts and Charting in Excel 2 January 10th 05 04:17 PM


All times are GMT +1. The time now is 05:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"