Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to change plot area size
Hello,
I have developed a Pie-chart with VBA in Excel XP. It creates a Pie-chart but its plot area size is too small. Furthermore, the Pie-chart does not let me manually change its size so I can not even record Maco. I wrote the following code but I got an error "Unable to set the Height property of the PlotArea Class". With ActiveChart .ChartType = xl3DPieExploded .PlotArea.Height = 155 .PlotArea.Width = 389 End With Any help is appreciated, Shinichi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 | |||
Size of plot area expands when Chart Title is deleted - why? | Charts and Charting in Excel | |||
How to change plot area size of pivot chart | Charts and Charting in Excel |