I have lots of graphs which I need to compare against each other. Therefore, I need a common scaling along the vertical (Y) axis. I'm encountering problems when pasting in my MIN/MAX series, and then hiding them, which I believe is commonly used to handle these types of issues.
My data is 6 columns and over 100 rows. I've created two rows at the bottom giving me a MIN and MAX series for each column.
I've highlighted the MIN/MAX range and tried copying and pasting them into the graph but the new series either 'embeds' itself within the real data series (see bold below). Giving me a totally wrong representation of the actual data.
Or, I've tried pasting them in as columns, which seems to work but then my legend includes them, but I don't want the MIN/MAX series to be visible at all.
Any examples or links to how to's showing me how this is meant to be done would be greatly appreciated.