I have a workbook with several charts. One chart (Settleometers ) works as i want, where when data stops so does the line. The others the line drops to 0 and extends to the end of chart. I'm almost sure i created them the same but have issues.
What did I do wrong.
I tried to upload workbook but the file is too big.

Thanks in advance.

Can you upload an abbreviated version?

I'll work on it.
So far as small as I can get it is 1.23 mb. and still have everything it needs to work.

I think I have figured out why it works on one chart and not the other.
The chart giving me issues has formulas in the cells it is drawing from.

That shouldn't matter.

Finally got it small enough to attach.

Attached Files

2020 Process Control Charts.xlsx (472.8 KB, 10 views)