| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
chart area size vba
How can I set the chart size of an existing active/selected chart?
I tried this withing a sub routine: With ActiveChart.ChartArea .Width = 5 .Height = 3 End With And get the error message: Unable to Set the Width Property of the ChartArea Class Any help is appreciated. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
chart area size vba
Hi,
If the chart is on a worksheet this will work, although your chart will be very small. With ActiveChart.Parent .Width = 5 .Height = 3 End With Cheers Andy wrote: How can I set the chart size of an existing active/selected chart? I tried this withing a sub routine: With ActiveChart.ChartArea .Width = 5 .Height = 3 End With And get the error message: Unable to Set the Width Property of the ChartArea Class Any help is appreciated. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Same size chart area over multiple charts | Charts and Charting in Excel | |||
| how to center a square plot area in a square chart | Charts and Charting in Excel | |||
| chart size | Charts and Charting in Excel | |||
| How do I alter plot area colour in a chart without a mouse? | Charts and Charting in Excel | |||
| Area Chart Formatting Question | Charts and Charting in Excel | |||
Linear Mode
