Dimitris Platis
New Member
- Joined
- Sep 13, 2020
- Messages
- 2
- Office Version
- 2019
- Platform
- Windows
I have 2 worksheets, one named 'Charts' where I place all my charts and one named 'Dump_Statistics' where I keep all my data. I have created dynamic ranges using Define names. The idea is to create a chart in the Chart worksheet using all of the data in a single column in worksheet Dump_Statistics.
Everything is well with creating the formula (using offset etc) (=OFFSET(Dump_Statistics!$A$3;0;0;COUNTA(Dump_Statistics!$A:$A)-1;1)) with a Workbook scope.
1) When I create the chart (Box and Whisker) in the worksheet Charts all is well. When I save and close and reopen excel (2019) the chart range is all screwed up and it only shows the A3 cell, instead of A3-end of rows.
2) Funny thing is, that when I create the same chart on the same worksheet as the data it works fine.
Any ideas???
Everything is well with creating the formula (using offset etc) (=OFFSET(Dump_Statistics!$A$3;0;0;COUNTA(Dump_Statistics!$A:$A)-1;1)) with a Workbook scope.
1) When I create the chart (Box and Whisker) in the worksheet Charts all is well. When I save and close and reopen excel (2019) the chart range is all screwed up and it only shows the A3 cell, instead of A3-end of rows.
2) Funny thing is, that when I create the same chart on the same worksheet as the data it works fine.
Any ideas???
