If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|