Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question

1 Answer 1

up vote 1 down vote accepted

If I understand your description you have 6 series of 100 values or so.

You need to add a new series (column) called "range" (or minmax or whatever you like) for the MIN and MAX, and that needs onyl two values - the MIN and the MAX for all the other values not separately calculate some value for each series.

Add this series to your chart (copy / paste it or alter the source data range).

Format the series so it is invisible (no line, no points, no colour, nothing).

Select the entry in the legend for this extra series (not the whole legend, so click once, then carefully click so you have only one item selected). Press delete to remove that from the legend.

Job done.

share|improve this answer
    
Your correct in your understanding. I have been doing what you suggested above, the only probelm was that when I pasted in to my chart it always added the new series into the other series and not as a separate series. I found a way around this though. Paste Special>choose new series>remove the tick from the Category X labe box. Then do as you mentioned> no line for the hidden series. The pasting was my problem not the formatting. –  RocketGoal Aug 18 '10 at 14:39

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.