VBA Delete Graph

[Analyze_This]

I have a chart that I need to get rid of as part of my code. I recorded this part of the macro and ended up with the following code

ActiveChart.Location Where:=xlLocationAsNewSheet, Name:="Graph-State-KU"
ActiveChart.CopyPicture
ActiveChart.Parent.Delete
ActiveChart.Pictures.Paste.Select

ActiveChart.Parent.Delete is where I get the error

Simple, right? It's what the macro recorder gave me, it's what everyone posts on the web when deleting a graph. But it always gives me the same error: "Object doesn't support this property or method"

The chart is in a sheet by itself, so I can't use activechart.delete because that deletes the entire sheet, not just the chart. Any ideas?

 

[GlennUK]

The chart is in a sheet by itself, so I can't use activechart.delete because that deletes the entire sheet, not just the chart.

... and why do you want to delete a chart from a chart sheet and NOT the chart sheet?