| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Charting with missing data or empty strings from vlookup() | Charts and Charting in Excel | |||
| Pie Charting with Missing and Changing Data | Charts and Charting in Excel | |||
| How do you stop excel from charting empty cells/null values as zer | Charts and Charting in Excel | |||
| charting non-adjacent data cells | Charts and Charting in Excel | |||
| Charting 3-D Graphs with Empty Cells | Charts and Charting in Excel | |||
Threaded Mode
