Update graph when date changes

English
#1

Is there a way to update the graph when the data table changes? The table range stays the same, only numbers in table change.

If the source range expands, I already know, how to manually change it. The graph adds then a new column based on the data. All well in that case. However, when the range stays the same but the numbers in table change, I can’t seem to be able to update the graph.

Doing the same graph over and over after each data update is tiresome. There should be a way to update the graph, when the data in specified table range changed.

Thank you

#2

Cannot reproduce, Chart gets updated after changes in the source-range!!
please test attached:
chart_example.ods (18.8 KB)

otherwise attach your file with the issue (without sensitive Data)

#3

Maybe this happens, because the chart is moved to another tab.

Can you copy or move the chart to another tab, change the source data and see if the chart updates?

Also, in my case, the source table is the pivot table, that I refresh for the data update.

#4

So please attach »your case« as ods-file (without sensitive Data)

#5

Making sensitive data obscure would involve a lot of manual work. Not worth it.

I suspect that the fact of cut-out and paste to another tab is breaking the link somehow, and that is why it won’t updates.

What I did this time is, instead of doing the graph on the same tab, I created it on the tab I wanted in the first place. This was very, very tricky, because defaults were completely different and it took me some time to figure them out, so the graph would look the same. Nevertheless, I hope the data will update next month automatically this time.

In general, using or editing graphs in LO is a broken, lacking and confusing experience at this moment, but that’s a huge topic with tons of things to write, so let’s skip it here.

Hopefully, next month I will be here reporting that the data update on the graph works. Will see.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.