Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
James Hamilton
 
Posts: n/a
Default Resize Multiple Graphs at Once

Hi,

I have a number of graphs of varying sizes on a sheet. How do I resize them
all simultaneously so that they are all of the same size?

Thanks!
  #2   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

James,

Select them (use the Shift key). Right-click one - Format object - Size
tab. Type in the height and width you want. Click OK. They'll all be set
to that size. If you want to change all the sizes again, select them all,
then drag a handle.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"James Hamilton" <James wrote in message
...
Hi,

I have a number of graphs of varying sizes on a sheet. How do I resize
them
all simultaneously so that they are all of the same size?

Thanks!



  #3   Report Post  
James Hamilton
 
Posts: n/a
Default

Thanks - this worked.

How do I now align them horizontally and vertically so that they are in a
nice looking grid?

Thanks again!

"Earl Kiosterud" wrote:

James,

Select them (use the Shift key). Right-click one - Format object - Size
tab. Type in the height and width you want. Click OK. They'll all be set
to that size. If you want to change all the sizes again, select them all,
then drag a handle.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"James Hamilton" <James wrote in message
...
Hi,

I have a number of graphs of varying sizes on a sheet. How do I resize
them
all simultaneously so that they are all of the same size?

Thanks!




  #4   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

James,

To align them, select them as before, then in the Drawing Toolbar, click
Draw - Align or distribute - Align to top/bottom, (doesn't matter since
they're now the same size) or left/center/right, as appropriate for how
they're laid out. To equally space them, use distribute, having the first
and last where you want them -- it moves the others until they're equally
spaced. Keep good-'ol Undo handy in case you mess up.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"James Hamilton" wrote in message
...
Thanks - this worked.

How do I now align them horizontally and vertically so that they are in a
nice looking grid?

Thanks again!

"Earl Kiosterud" wrote:

James,

Select them (use the Shift key). Right-click one - Format object - Size
tab. Type in the height and width you want. Click OK. They'll all be
set
to that size. If you want to change all the sizes again, select them
all,
then drag a handle.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"James Hamilton" <James wrote in
message
...
Hi,

I have a number of graphs of varying sizes on a sheet. How do I resize
them
all simultaneously so that they are all of the same size?

Thanks!






  #5   Report Post  
James Hamilton
 
Posts: n/a
Default

Thanks Earl.



"Earl Kiosterud" wrote:

James,

To align them, select them as before, then in the Drawing Toolbar, click
Draw - Align or distribute - Align to top/bottom, (doesn't matter since
they're now the same size) or left/center/right, as appropriate for how
they're laid out. To equally space them, use distribute, having the first
and last where you want them -- it moves the others until they're equally
spaced. Keep good-'ol Undo handy in case you mess up.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"James Hamilton" wrote in message
...
Thanks - this worked.

How do I now align them horizontally and vertically so that they are in a
nice looking grid?

Thanks again!

"Earl Kiosterud" wrote:

James,

Select them (use the Shift key). Right-click one - Format object - Size
tab. Type in the height and width you want. Click OK. They'll all be
set
to that size. If you want to change all the sizes again, select them
all,
then drag a handle.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"James Hamilton" <James wrote in
message
...
Hi,

I have a number of graphs of varying sizes on a sheet. How do I resize
them
all simultaneously so that they are all of the same size?

Thanks!






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
How do I put multiple graphs on one axis? TheDud Charts and Charting in Excel 1 April 11th 05 04:22 AM
How do I show multiple worksheets on multiple screens? needville guy Excel Discussion (Misc queries) 0 April 3rd 05 04:15 AM
resize chart on copyo meyerse Charts and Charting in Excel 1 March 26th 05 07:41 AM
graphs from multiple worksheet : query Lia Charts and Charting in Excel 1 January 8th 05 04:49 AM
XML / parent with multiple children and with multiple children Richard Excel Discussion (Misc queries) 0 January 5th 05 11:49 AM


All times are GMT +1. The time now is 02:29 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"