Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I put multiple graphs on one axis? | Charts and Charting in Excel | |||
How do I show multiple worksheets on multiple screens? | Excel Discussion (Misc queries) | |||
resize chart on copyo | Charts and Charting in Excel | |||
graphs from multiple worksheet : query | Charts and Charting in Excel | |||
XML / parent with multiple children and with multiple children | Excel Discussion (Misc queries) |