| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Bar showing value for missing data
I have a bar chart that shows data for 2004. I deleted the data and the
source data in the chart is showing as =summary!#REF!. Any idea why this bar would still be showing a value? |
|
#2
|
|||
|
|||
|
smboyd,
One possibility - if you deleted the data by deleting the underlying rows or columns that held that data, the chart will show a #ref! error as you have noted. To get around this behavior, rather than deleting the rows or columns that hold the data, change the chart data reference to an area with blank cells. ---- Regards, John Mansfield http://www.pdbook.com "smboyd" wrote: I have a bar chart that shows data for 2004. I deleted the data and the source data in the chart is showing as =summary!#REF!. Any idea why this bar would still be showing a value? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with data not getting plotted | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Linear Mode
