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

  • Thread starter Thread starter Dick Watson
  • Start date Start date
D

Dick Watson

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.
 
Gee, that was easy. I don't know that I'd ever even noticed that button...
Thanks a lot!
 
Back
Top