Resizing Surface Charts

A

Andy Pope

Hi Stefko,

Have you tried adjusting the plotarea?

To select the plotarea either use the chart toolbar and select it from
the chart items droplist or select the chart and use the up/down cursor
keys to cycle thru the chart elements.

Cheers
Andy
 
J

Jon Peltier

The problem might be that Excel keeps the size of the between-tick
spacing the same on the X and Y axes. If you have 5 X categories and 2 Y
categories, your chart will be much longer in the X direction than in
the Y. I have not found a good way to get around this, but if the data
is reasonably smooth, I might insert a range in the shorter dimension
and enter interpolated values, to stretch out the axis.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Select Multiple Emails using Surface Pen 0
surface chart 1
Combining a Surface Chart With a Scatter Plot 1
scales on surface / contour charts 1
surface charts in 2-D 2
Filtered view of Visio Chart 0
Cannot see and gantt charts or other displays 0
How do I chart contours in Excel 2007? 2

Top