Specify dimensions for Excel charts
 

It would be great if one could actually specify the dimensions of the axes of
a graph, or the graph itself without eyeballing. Could ther for example be a
function hat lets me set the lenths of the x and y axes to 4 inches by 4
inches. I do not want to esimate anything.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting

Specify dimensions for Excel charts
 

You can do the whole chart. Hold Shift, then click on the chart, so it is
surrounded by white handles, not black handles. Go to Format menu Object,
and on the Size tab, set the size. This works on the overall chart object,
not the plot area, which is the rectangle defined by the axes. Adjusting
these to fit a predetermined size requires VBA programming.

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


"sgl8akm" wrote in message
...
It would be great if one could actually specify the dimensions of the axes
of
a graph, or the graph itself without eyeballing. Could ther for example be
a
function hat lets me set the lenths of the x and y axes to 4 inches by 4
inches. I do not want to esimate anything.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting