Delete chartobject without deleting ALL charts on sheet

Good day I have created various charts using the the following code and place them on to sheet 2. However, I want to delete 1 chart from the sheet and not all of them. How do I delete a specific chart?

Please Login or Register  to view this content.

of course you then need to know the index of the chart you want to delete.

The easiest way is to set the name of the chart as you create it, then you can refernce it by name if you need to edit it later

Hi I have tried to do this but it doesnt seem to work. I have tried this:

Please Login or Register  to view this content.

and then tried to delete it with the following code

Please Login or Register  to view this content.

But it doesnt seem to work

Yes it does give me an error

I put a msgbox after

[Code]
.Chart.Name = "SAIDI CNC"
MsgBox .Chart.Name
[\Code]

and it returns Sheet2 Chart 2289 in the msgbox and not SAIDI CNC, thus something must be wrong in the naming??

I used the following code and it seems to have worked.

Please Login or Register  to view this content.