| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Avoiding empty cells showing as zero in line chart without na()
Hi,
You could change the average formula such that NA() can be used, =AVERAGE(IF(ISNUMBER(A1:A10),A1:A10)) Array formula so commit with CTRL+SHIFT+ENTER Cheers Andy wrote: I'm using a line graph to show trends in a multi-question questionnaire. Like many else (I've done a lot of searching but haven't found a suitable solution) my line graph jumps to zero for the empty cells (currently defined as ""). I understand I could just change this to na() instead but then my average() calculation stops working. I have a lot of data so making two separate data-series is not feasible. Can anyone help me with a suggestion here? Thanks! -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to add a Vertical Line to a Column or Line Chart with two axes already in use? | Charts and Charting in Excel | |||
| Calculating only non-empty cells... | Excel Worksheet Functions | |||
| Excel chart draws line outside Y axis | Charts and Charting in Excel | |||
| how can I limit my chart | Charts and Charting in Excel | |||
| pivot table multi line chart | Charts and Charting in Excel | |||
Hybrid Mode
