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.

The problem with your chart is that you didn’t define an X range. Since you are using an XY Plot and no range is defined for the X axis, Calc (wisely) uses the column number as the X category.

In this particular case you should use cells E1 to AMF1 (assuming Datum means Date) as the X-axis.

http://dl.dropbox.com/u/2347109/test_mod.ods

I’ll check it out, thank you.

Can you provide a link to an example file? The problems probably depend on the type of chart and organization of the data…

http://www.mediafire.com/?99a1b7gopaxaplb

I marked the range on the second sheet… change it, so it works hehe :smiley: thank you