activesheet.shapes.addchart

[ammartino44]

Hello. Why do I have to add the "shapes" in this code?

Please Login or Register  to view this content.

[Andy Pope]

becuase addchart is a method of the shapes collection. The sheet object does not have a method to directly add charts.

you could also use the chartobject collection but you need to provide dimensions for the chart.

So either of these will work

Please Login or Register  to view this content.