Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
merritaf
 
Posts: n/a
Default Making mutiple graphs the same size

We are trying to print four graphs that are identical in size and format on
one sheet. Is there an easy way to get them of equal size? Or how would you
go about doing this.
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default Making mutiple graphs the same size

Naturally this is done with charts embedded in a worksheet.

One way is to make one chart 1/4 of the size you need, then make 3
copies and change the data range of each to cover the four charts.

Another way is to use the ALT key while moving and resizing the charts
so that their edges line up with cell boundaries. This is a pretty easy
way to make charts the same number of rows and columns in size.

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


merritaf wrote:

We are trying to print four graphs that are identical in size and format on
one sheet. Is there an easy way to get them of equal size? Or how would you
go about doing this.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Make graphs in Excel all the same size ready to paste into Word - sub210 Charts and Charting in Excel 4 April 25th 23 11:47 AM
How do I print graphs poster size (4 - 8 1/2 x 11) in Excel 2002? Library Dragon Charts and Charting in Excel 1 June 26th 05 04:22 PM
Font size prints same size regardless of how I set it in Excel Marcusmouse Excel Discussion (Misc queries) 2 May 26th 05 03:25 PM
Excel resizing Graphs meyerse Charts and Charting in Excel 3 March 26th 05 10:55 PM
making graphs ignore "blank " cells Guillermo Excel Discussion (Misc queries) 4 February 22nd 05 09:26 PM


All times are GMT +1. The time now is 12:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"