Forum Discussion
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...
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?
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.