Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenMon, 05 Mar 2012 13:22:21 +0100Calc "chart update"https://ask.libreoffice.org/en/question/913/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.Mon, 05 Mar 2012 09:30:44 +0100https://ask.libreoffice.org/en/question/913/calc-chart-update/Answer by Pedro for <p>I have a chart that has a data range of 1000+ columns.</p>
<p>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"".</p>
<p>I would like to know how I would go about doing that.</p>
<p>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?</p>
<p>Thank you.</p>
https://ask.libreoffice.org/en/question/913/calc-chart-update/?answer=916#post-id-916Can you provide a link to an example file? The problems probably depend on the type of chart and organization of the data...Mon, 05 Mar 2012 11:19:06 +0100https://ask.libreoffice.org/en/question/913/calc-chart-update/?answer=916#post-id-916Comment by mkrmec for <p>Can you provide a link to an example file? The problems probably depend on the type of chart and organization of the data...</p>
https://ask.libreoffice.org/en/question/913/calc-chart-update/?comment=917#post-id-917http://www.mediafire.com/?99a1b7gopaxaplb
I marked the range on the second sheet... change it, so it works hehe :D thank youMon, 05 Mar 2012 12:10:09 +0100https://ask.libreoffice.org/en/question/913/calc-chart-update/?comment=917#post-id-917Answer by Pedro for <p>I have a chart that has a data range of 1000+ columns.</p>
<p>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"".</p>
<p>I would like to know how I would go about doing that.</p>
<p>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?</p>
<p>Thank you.</p>
https://ask.libreoffice.org/en/question/913/calc-chart-update/?answer=918#post-id-918The 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
Mon, 05 Mar 2012 12:57:55 +0100https://ask.libreoffice.org/en/question/913/calc-chart-update/?answer=918#post-id-918Comment by mkrmec for <p>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.</p>
<p>In this particular case you should use cells E1 to AMF1 (assuming Datum means Date) as the X-axis.</p>
<p><a href="http://dl.dropbox.com/u/2347109/test_mod.ods">http://dl.dropbox.com/u/2347109/test_mod.ods</a></p>
https://ask.libreoffice.org/en/question/913/calc-chart-update/?comment=919#post-id-919I'll check it out, thank you.Mon, 05 Mar 2012 13:22:21 +0100https://ask.libreoffice.org/en/question/913/calc-chart-update/?comment=919#post-id-919