Specify dimensions for Excel charts

G

Guest

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/com...f01178d59f&dg=microsoft.public.excel.charting
 
J

Jon Peltier

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/
_______
 

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

Top