Change a chart without selecting it

[Fyr]

I have a chart called INCOMEGRAPH.
I wrote a macro to remove a series if the chart was selected.
But I would like to not select the chart just to delete.

I thougth this might work

With Chart("INCOMEGRAPH")
.SeriesCollection("JAN").Delete
End With

But it does not. How would I refer to a chart without making it ActiveChart?

Thanks for taking a look!

 

[circledchicken]

Hi,

Try this:

With Sheets("Sheet1").ChartObjects("INCOMEGRAPH")
    .Chart.SeriesCollection("JAN").Delete
End With

You can replace Sheets("Sheet1") with ActiveSheet or Sheet1 etc.

I find Jon Peltier's website awesome for information about all kinds of things charts related:
http://peltiertech.com/Excel/Charts/