07-14-2020 05:42 AM - edited 07-14-2020 06:34 AM
Hi,
I have table, from which are updating many charts. And i don't know why, some of charts have stopped to update automatically. It have never happened before. I inserted new week in table, and half charts picked it up automatically, but some not.
How can i fix this?
Thank You
07-14-2020 10:06 AM
My guess: check the data source that is identified for each of charts. I'd guess that there is an inconsistency in those connections.
If you want more than a guess, it would help if you posted the workbook itself, so long as there's no confidential information in it.
07-16-2020 02:54 AM
Hi,
Yeh you was right, when i went to select data, field "Chart data range" was empty, so i selected all table, updated "legend entries" and it is working now. And it was for all charts which didn't worked. Toke time to update them all ....
Interesting...it have been working for weeks...and why it went blank....
(unfortunately i can't share file)