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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to change plot area size
The height and width can not exceed the chart size.
Try something like this before your code: Sub resizePie() ActiveSheet.ChartObjects("Chart 2").Activate ActiveChart.ChartArea.Select Worksheets("Sheet4").ChartObjects("Chart 2").Height = 1500 Range("A1").Select End Sub -----Original Message----- 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 . |
Reply |
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 |