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?