charting missing data (empty cells bug)
Hi
I'm trying to chart data with some missing points. I read posts on this forum on this topic and checked with my settings but they seem to be OK. Still, my empty cells are plotted as zeros. Only one (!) cell out of 5 is not plotted(and I failed to figure out how that one was different from the rest). Here are the current settings: - Excel version is French. - Cells are not hidden, but protected. - They are customized at "empty cell" format (;;;) - Empty cells are set to be plotted as gaps. Your help would be very much appreciated. EggHeadCafe - Software Developer Portal of Choice ..NET string.Split("::") Bug With Duplicate Delimiters http://www.eggheadcafe.com/tutorials...ngsplit-b.aspx |
Excel 2007
Oh, I almost forgot it: I'm using the 2007 version
Kazim Mammadhuseyn wrote: charting missing data (empty cells bug) 26-oct.-09 Hi I'm trying to chart data with some missing points. I read posts on this forum on this topic and checked with my settings but they seem to be OK. Still, my empty cells are plotted as zeros. Only one (!) cell out of 5 is not plotted(and I failed to figure out how that one was different from the rest). Here are the current settings: - Excel version is French. - Cells are not hidden, but protected. - They are customized at "empty cell" format (;;;) - Empty cells are set to be plotted as gaps. Your help would be very much appreciated. Previous Posts In This Thread: EggHeadCafe - Software Developer Portal of Choice Identities, Roles, Database Forms Authentication http://www.eggheadcafe.com/tutorials...es-databa.aspx |
charting missing data (empty cells bug)
Hi,
Charts take a cell with content that is not numeric as being text and as such treat it as zero. If your cell contains a formula you need to set the resulting unused value using the NA() So your formula construct will be along the lines of if not a valid value use NA() IF(<test , <value . NA() ) Note that regardless of the setting for how to chart empty cells the use of NA() will only suppress the data marker. If you have a line and require a break within it you will need to remove the formula from the cell. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Kazim Mammadhuseyn" wrote in message ... Hi I'm trying to chart data with some missing points. I read posts on this forum on this topic and checked with my settings but they seem to be OK. Still, my empty cells are plotted as zeros. Only one (!) cell out of 5 is not plotted(and I failed to figure out how that one was different from the rest). Here are the current settings: - Excel version is French. - Cells are not hidden, but protected. - They are customized at "empty cell" format (;;;) - Empty cells are set to be plotted as gaps. Your help would be very much appreciated. EggHeadCafe - Software Developer Portal of Choice .NET string.Split("::") Bug With Duplicate Delimiters http://www.eggheadcafe.com/tutorials...ngsplit-b.aspx |
All times are GMT +1. The time now is 12:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com