First time here? Check out the FAQ!
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?
answered 2012-03-05 12:57:55 +0200Pedro
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.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-03-05 09:30:44 +0200
Seen: 582 times
Last updated: Mar 05 '12