How to remove Series "#Ref!" for Xl07 chart?

I deleted some data series that were used in several charts. Now the charts
still have the series, but it's been changed to a reference error. I can't
find any way to get to those series and delete them.

Anybody know how to delete these Series "#Ref!" objects from an Xl07 chart?
How?

Hi Dick,

1. Select the chart
2. Choose Chart Tools, Design, Select Data.
3. Select the series on the left (under Legend Entries...) and click Remove.
If you don't know which series it is, click Edit to see if that is the
series you want to delete - you will see the Ref error.

--
Cheers,
Shane Devenshire


"Dick Watson" wrote:

> I deleted some data series that were used in several charts. Now the charts
> still have the series, but it's been changed to a reference error. I can't
> find any way to get to those series and delete them.
>
> Anybody know how to delete these Series "#Ref!" objects from an Xl07 chart?
> How?
>
>
>

Gee, that was easy. I don't know that I'd ever even noticed that button...
Thanks a lot!

"ShaneDevenshire" <ShaneDevenshire@discussions.microsoft.com> wrote in
message news:8DBA3274-69C9-4FF7-A408-29B29D50A54A@microsoft.com...
> 1. Select the chart
> 2. Choose Chart Tools, Design, Select Data.
> 3. Select the series on the left (under Legend Entries...) and click
> Remove.
> If you don't know which series it is, click Edit to see if that is the
> series you want to delete - you will see the Ref error.