I have a chart that has a data range of 1000+ columns.
At start all of them are empty. Gradually when we enter data, I would like that the chart is auto updated with just the “available data” and not "available data + all the empty ones as “0"”.
I would like to know how I would go about doing that.
EDIT
I just saw that the only thing not updating is the X axis. It’s not adding the space for new Y values. Sooo… how do I fix this?
Thank you.