Forum Discussion
Solved
why is my dynamic chart plotting blank points as zero?
Hello, I am working on a template for charting data. I want to be able to use a dynamic named ranges for series data so the chart is dynamic and I don't need to manually update the series data e...
emmalc2950 Change the double quotes at the end of the named ranges to NA(). That should fix it. A double quote is not considered an empty cell when plotting a line, whereas NA() will generate an #N/A error which will be ignored.
emmalc2950 Change the double quotes at the end of the named ranges to NA(). That should fix it. A double quote is not considered an empty cell when plotting a line, whereas NA() will generate an #N/A error which will be ignored.
Riny_van_Eekelen that fixed it! thank you so much! I knew I was close but stared at it too long, that was so much easier than all the complex offset equations I was finding online!