| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
charts with #N/A and other "non"-data
Greetings:
I am charting data which is not contiguous. If I leave a cell empty, the chart treats it like a zero (which it isn't). If I drop a #N/A into the cell, the chart ignores it, which is fine. On the downside, if there's a #N/A within the base data, AVERAGE() will return #N/A too. I'd like to have my cake and eat it too. Suggestions? Thanks; Duncan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Some charts won't let data labels to be at "Outside end" | Charts and Charting in Excel | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Excel 2003 - Charts - "Data Range" and Date/Time data on X-Axis | Charts and Charting in Excel | |||
| Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
| Adding "New" "Insert" "Delete" into a workbook to change from data 1 to data 2 etc | Excel Programming | |||
Threaded Mode
