Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Resizing a Graph/Chart in Excel
I am trying to resize a few graphs/charts in Excel so they are exactly the
same size. I know you can drag the graphs to the correct size, but I need them to be exactly the same size. How do you get the box up so you can manually enter a height and width? I know it can be done because I have done it once before but I can't seem to be able to do it again! Thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Resizing a Graph/Chart in Excel
Hi,
Select the chart whilst holding the SHIFT key. This will select the chart as an object and you should see white circle grab handles instead of the usual black squares. You can then press F1 to get the format dialog and use the Size tab. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Sarah" wrote in message ... I am trying to resize a few graphs/charts in Excel so they are exactly the same size. I know you can drag the graphs to the correct size, but I need them to be exactly the same size. How do you get the box up so you can manually enter a height and width? I know it can be done because I have done it once before but I can't seem to be able to do it again! Thanks |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Resizing a Graph/Chart in Excel
Thanks Andy - you have stopped me from going crazy!
"Andy Pope" wrote: Hi, Select the chart whilst holding the SHIFT key. This will select the chart as an object and you should see white circle grab handles instead of the usual black squares. You can then press F1 to get the format dialog and use the Size tab. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Sarah" wrote in message ... I am trying to resize a few graphs/charts in Excel so they are exactly the same size. I know you can drag the graphs to the correct size, but I need them to be exactly the same size. How do you get the box up so you can manually enter a height and width? I know it can be done because I have done it once before but I can't seem to be able to do it again! Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Resizing chart labels | Charts and Charting in Excel | |||
Resizing Chart window using VBA | Charts and Charting in Excel | |||
Resizing chart because of refreshing Chart Data through a query | Charts and Charting in Excel | |||
Automatically Resizing a Graph | Excel Discussion (Misc queries) | |||
Chart resizing handles | Charts and Charting in Excel |