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?)