Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Calc "chart update"

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.

Thank you.

Calc "chart update"

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.