Hey all Mr Excel fans-
Hope there's somebody out there who can help me.
I have a spreadsheet with several worksheets and charts.
If i close and save my spreadsheet and open it again one of my charts changes its data references so it becomes identical to another chart in my spreadsheet. I don't have any startup macroes or anything fancy.
Does anybody have a clue why this is happening and what I can do to solve this problem?
The chart is a Waterfall chart and I'm using Excel 2016.
Kind regards
P Stark
Hope there's somebody out there who can help me.
I have a spreadsheet with several worksheets and charts.
If i close and save my spreadsheet and open it again one of my charts changes its data references so it becomes identical to another chart in my spreadsheet. I don't have any startup macroes or anything fancy.
Does anybody have a clue why this is happening and what I can do to solve this problem?
The chart is a Waterfall chart and I'm using Excel 2016.
Kind regards
P Stark