cannot set plotarea size

[Nicky]

Hi
I'm trying to fix the size of the plot area of an embedded chart, but:
ActiveChart.PlotArea.Height = 240
doesn't seem to have any effect. The chart area is large enough to accomodate the change.

Any suggestions?

[Bryan Hessey]

Hi
I'm trying to fix the size of the plot area of an embedded chart, but:
ActiveChart.PlotArea.Height = 240
doesn't seem to have any effect. The chart area is large enough to accomodate the change.

Any suggestions?

Hi,

What sort of chart, it should work,

    ActiveChart.PlotArea.Select
    Selection.Top = 1
    Selection.Width = 227
    Selection.Height = 240

works for me.

hth
---

[Nicky]

Hi
It's a mixed bar/line chart embedded on a worksheet (I have no problem with using this code on chart sheets). Either the size doesn't change, or sometimes it changes to a different size than I specify, but often it adjusts the plotarea height to the largest that will fit the chartarea (about 280 points, when I want it to be 240 high).

[Bryan Hessey]

Hi
It's a mixed bar/line chart embedded on a worksheet (I have no problem with using this code on chart sheets). Either the size doesn't change, or sometimes it changes to a different size than I specify, but often it adjusts the plotarea height to the largest that will fit the chartarea (about 280 points, when I want it to be 240 high).

Have you tried recording a Macro and manually setting the size to see what happens? - is there a hieght-width ratio setting with no room to adjust width?

---

[Nicky]

Bryan, yes, I can change the height manually, there doesn't seem to be a fixed proportion of height to width. But when I record the action of setting the height and play it back, it doesn't work.

[Bryan Hessey]

Bryan, yes, I can change the height manually, there doesn't seem to be a fixed proportion of height to width. But when I record the action of setting the height and play it back, it doesn't work.

Hi,


re-tested, and it should. Did you try the macro immediately after recording (and resizing) ?

Could this be an old '95 or '97 book updated to the current version?

Do other chart option 'set' correctly in this area of code, ie
ActiveChart.ChartType = xlPie
or
ActiveChart.SeriesCollection(2).Select
ActiveChart.SeriesCollection(2).AxisGroup = 1
etc

any more clues?
---