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.
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 :D thank you
mkrmec ( 2012-03-05 12:10:09 +0200 )editLibreOffice 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
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
