I need to compare 8 charts, and their Max and min scales are all over the place. Therefore I've done some research and found that a common method is to create a new series that takes the MIN and the MAx of my data, and then copy and paste this series in to the charts. Change the data lines to no-line, and hey-presto.
This seemed to work as all my charts had the the same Min/Max scale/axis. Unfortunately the pasted series added to my original data and therefore actually changed my results.
How do I use the MIN and MAX common scaling technique so that the user is unable to see the Min/Max series - neither in the legend or the chart? Or, is there a better way to force all the axis to be the same on all 8 charts?
Many thanks for your help.