PlotArea is different between Excel 2003 and Excel 2007

[bill]

All,

I am having difficulty programmatically changing chart parameters. For
instance, I want to modify the PlotArea.Height of one of my charts.
When I resize it manually (i.e. increase the PlotArea by a factor of
three) everything scales just fine. When I try to set <chart>.PlotArea
in VB I get an error message:

Number: 1004
Description: Chart Layout Failed

Any thoughts?

Bill

 

[Andy Pope]

Hi,

Is that VB or did you really mean VBA?
And can you post the code you are using.


Cheers
Andy

 

[bill]

Hi,

Is that VB or did you really mean VBA?
And can you post the code you are using.

Cheers
Andy

--










- Show quoted text -

Hi Andy,

VBA. Here is some of the code. The stuff in between is too ugly to
post. Basically, the chart is created, populated, and that is it:

......

Set zNewChart = zNewBook.Charts.Add(After:=zNewBook.Sheets(nChartCtr))

.....
add data series
label axes
fill in title
... bunch of other stuff .....


zNewChart.PlotArea.Height = zNewChart.PlotArea.Height - 20 ' this is
the spot where the error message occurs


The other anomaly is that if I put a breakpoint on the above, and then
continue, it does not generate an error. However, the PlotArea.Height
does not really change. Also, when I look at the Height before trying
to change it, it has a value of 473.xxxx. However, when I open the
spreadsheet and check it out, it is clearly not 473 in Height because
the DataTable is taking up around 4/5 of the chart area. In addition
to all of this, if I change Height immediately after instantiating the
chart, then there is no error message. However, the final Height of
the PlotArea is still entirely different than 453 (i.e. it is much
smaller).

Hope that wasn't too confusing,

Bill

 

[Andy Pope]

Hi Bill,

It wasn't confusing
But I am unable to replicate your error. For me adjusting the height of
the plotarea works.

The new chart OM is a little flakey. So you may have some luck by simply
messing with properties in order to get the chart to refresh itself.

If you want you can email me the file offline and I will take a look.

Cheers
Andy

 

[Jon Peltier]

There occasionally seem to be problems in 2007 with charts that were created
in an earlier version of Excel.

- Jon

 

[bill]

There occasionally seem to be problems in 2007 with charts that were created
in an earlier version of Excel.

- Jon

Except that I am creating then from scratch in 2007.

Bill