Forum Discussion
Chart with Dynamic Data using Excel Online
I want to create a line chart with columns AV and AX below. The thin is on AV is an array formula that gets date from other sources and on AX I have a formula to calculate the cell data: =IF(OR(AW27=...
If you intended to upload a picture of the chart, it didn't work. But try to use NA() rather than " " in your IF(OR...... formula. That returns real N/A errors and you can set the chart to ignore them without the line dropping down to zero.