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.

SERIES(BEL!$N$2,(BEL!$C$204:$C$404,

BEL!$M$1611:$M$1612),(BEL!$N$204:$N$404,BEL!$N$1611:$N$1612),2)

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.