Share via

excel vba chart layout failed

Anonymous
2013-10-30T09:38:03+00:00

I saw another post on this topic but it has not been answered.  I have the same problem.  I have 15 charts with the same format and 4 others with different formats.  I do the exact same thing with all of the group of 15 but after the 6th one the remaining charts are corrupted. 

The object containing them is ok

The chart object has a name and the first level of direct properties all seem OK

The ChartArea property has Top and Left properties OK but Height and Width are failed, with the Chart Area Layout Failed error.

The plot Area property has the same error on all dimensional properties, including Top and Left.

Excel 2013 crashes when I try to scroll down towards the charts with the errors

Excel 2010 just shows the error'ed charts as zero size

Can someone recommend a resource where I can research all about using charts in vba?

There seems to be quite a few oddities resulting from legacy issues.

Thanks!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-11-04T14:44:35+00:00

    Just to close this off, the problem was due to setting the chart area the same size as the ChartObject size.  It needs to be a little smaller.  Could be the same issue with the plot vs chart area as well... I just set them all progressively smaller and the problem was fixed.

    Its a pity there wasn't some actual specifications available for this type of thing.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments