Forum Discussion

RodMorais's avatar
RodMorais
Copper Contributor
Dec 07, 2024

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=" ";AX26=" ");" ";AW27 + AX26).

 

I need to select AV1:AV1000 and AX1:AX1000 but excel online is not treating empty cells as zero. I tried already several approaches including using #NA, N/A or " " on AX and the chart shows a tiny portion of data and then  the line goes to zero. due to the other rows that are selected but empty. Any tips?

 

Charting
Excel for web
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Dec 09, 2024

    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.

Resources