Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How can I adjust the size of the plot area with VBA?
Here's what I've done After I selected the plot area, I run this macro, MsgBox Selection.Top MsgBox Selection.Height And then, I tried to change the size of the Plot area by using this code, ActiveSheet.ChartObjects(1).Activate ActiveChart.PlotArea.Select With Selection .Top = 20 .Height = 60 End With However, when I checked the size with the MsgBox, they were not the size I specified. What's wrong with the code? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Increase plot size within Chart area | Charts and Charting in Excel | |||
Excel2007 -- Precisely set plot area size? | Charts and Charting in Excel | |||
Excel Chart Plot Area Auto Size | Charts and Charting in Excel | |||
How to change plot area size of pivot chart | Charts and Charting in Excel | |||
Unable to change plot area size | Excel Programming |