Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 1st 05, 05:25 PM
smboyd
 
Posts: n/a
Default 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   Report Post  
Old February 1st 05, 10:53 PM
John Mansfield
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with data not getting plotted Scott Ehrlich Excel Discussion (Misc queries) 2 January 25th 05 06:17 AM
Help with data not getting plotted Scott Ehrlich Charts and Charting in Excel 1 January 23rd 05 06:15 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 06:55 PM
Charting data ranges that change mikelee101 Charts and Charting in Excel 2 December 17th 04 12:07 AM
Running Data Table using an input that triggers DDE linked data [email protected] Excel Discussion (Misc queries) 1 December 16th 04 12:56 PM


All times are GMT +1. The time now is 02:25 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017