| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to remove Series "#Ref!" for Xl07 chart?
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? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to remove Series "#Ref!" for Xl07 chart?
Gee, that was easy. I don't know that I'd ever even noticed that button...
Thanks a lot! "ShaneDevenshire" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Best way to "turn off" a data series on a chart? | Charts and Charting in Excel | |||
| How to entre a "pattern" in a column chart? "used to be in 2003" | Excel Discussion (Misc queries) | |||
| How to create a scatter chart with 2 "X" values with common "Y"s | Charts and Charting in Excel | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Hybrid Mode
