View Single Post
  #4   Report Post  
Bethany
 
Posts: n/a
Default How can I get several graphs on one Excel page?

Right!! I think I've got it. The trick was to make the graphs full size
first, and to resize them later; making a small graph to start with merely
leaves white opaque space around the edge. Likewise to copy I can then copy
the whole page, not just the graph axes area which does'nt work.

This has been great advice, thanks.

"Jon Peltier" wrote:

I assume you're placing the charts onto a worksheet. You can line the
charts up with the cell boundaries if you hole ALT while moving and
resizing the charts.

If you think ahead, you should make the first chart, and get it all
formatted the way you like it. Then make a copy of the chart; I like to
hold CTRL while dragging the chart to the new location. Finally, change
the data source, using the Source Data command from the Chart menu, and
the Series tab: change the range indicated in the boxes for each series.

This way you are not changing the size of chart elements after setting
them in the first chart.

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


Bethany wrote:
I'm trying to get four graphs of equal size on one page of Excel. I want them
to display in the four quarters of the page. When I try to make the second
graph match the first one, it comes out tiny with a big space around.
Resizing them is then subject to hit-and-miss. Is there any way to get this
to happen neatly and automatically? Thanks.