Forum Discussion
JoaoMW
Oct 25, 2022Copper Contributor
Chart selection of data changes everytime I reopen the file
Hi there, I'm using a lot of series within excel charts for a while and somehow the past two weeks every time i reopen my excel file the charts aren't as I left them. Some series get shorter while ot...
Patrick2788
Oct 25, 2022Silver Contributor
It's difficult to recommend a solution without knowing the data source for your charts. The behavior you're describing sounds like the data series are based on old school dynamic named ranges (OFFSET/COUNTA). What is the data source for your charts?
JoaoMW
Oct 25, 2022Copper Contributor
The charts pick data from manually updated tables. Some of the tables have information wich are disposed horizontaly other verticaly (Time [weeks] in somes is horizontal, others vertical).
But I managed to solve it by changing the series order. The first series were the ones that the information was horizontal and also the ones wich I used to filter. I realized that the selection of data was being cut by the last filter that i used (I was cutting off weeks 44 to 52, those were the weeks that disappeared when i reopened the file). Changing the order is working for now at least.
Thank you for your attention.