View Single Post
  #3  
Old September 5th, 2008, 02:31 PM posted to microsoft.public.excel.charting
royjacob
external usenet poster
 
Posts: 2
Default Surface Chart/Contour Chart options

John,

I right clicked and choose format from the top screen but I did not see any
option to choose scale. I clicked the size button and that opened a window
that named "Size and Properties". This had a section called "Size and
rotate", "Scale", "Crop From", and "Origional Size". However the "Scale"
function was grayed out.

Regards
Roy

"Jon Peltier" wrote:

Right click on the legend, choose Format, and set the scale on one of the
tabs.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"royjacob" wrote in message
...
Hello,

I am trying to make a 2d surface chart from some data i have collected.
When i plot the data using the Wireframe Contour option I get a 2d surface
plot where Excel sets the legend into 5 categories(ie from 0-2, 2-4, 4-6,
6-8, and 8-10). Is there a way to increase these catergories and choose
what
data Excel lumps ito these categories so that my graph will have more
countours? (IE so that i could set it to be from 0-1, 1-2, 3-4, 4-5, 5-6,
7-8, 8-9, and 9-10 so that i would have 10 contours on my graph rather
then
5?)