| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Aligning charts in excel
I have a series of charts on the same worksheet in excel. Is there a way to
align them without having to drag them manually (like the function in PowerPoint)? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Aligning charts in excel
Hi,
You can align the chartobjects easily enough using the Alignment options on the Drawing toolbar. To select charts as objects rather than activecharts hold the CTRL key when selecting the charts. Is that the same method in powerpoint? Align items within charts, such as plotarea, will require vba code. Cheers Andy Lesley wrote: I have a series of charts on the same worksheet in excel. Is there a way to align them without having to drag them manually (like the function in PowerPoint)? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Aligning charts in excel
Brilliant! Many thanks. I knew there should be something, just didn't know
how to select them all at once. "Andy Pope" wrote: Hi, You can align the chartobjects easily enough using the Alignment options on the Drawing toolbar. To select charts as objects rather than activecharts hold the CTRL key when selecting the charts. Is that the same method in powerpoint? Align items within charts, such as plotarea, will require vba code. Cheers Andy Lesley wrote: I have a series of charts on the same worksheet in excel. Is there a way to align them without having to drag them manually (like the function in PowerPoint)? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically resize excel charts when exporting them to PowerPoin | Charts and Charting in Excel | |||
| How do I create new default color settings for charts in Excel? | Charts and Charting in Excel | |||
| Excel Charts | Charts and Charting in Excel | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| I'm loosing colour when copying charts from excel to word. | Charts and Charting in Excel | |||
Linear Mode
