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

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?
 
S

ShaneDevenshire

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.
 
D

Dick Watson

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Error Bars to Series and Colour 1
Stack Chart Help 1
Not plot a data series in a chart but still display in data table 1
Remove series from Pivot Chart 2
For chart syles, why doesn't color order match series order? 1
Remove series from pivot chart 1
How do I find the series associated with a given legend entry. 4
select a series that is transparent for formatting in a bar chart 1

Top