Select the chart first so it has eight black "handles" on the corners and
edges (not white handles). Then right click on the legend, and choose Format
Legend.

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


"royjacob" wrote in message
...
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?)