• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

My MIN MAX series is not working 'correctly' within my charts.

NeverHappyMike

NeverHappyMike

Member
Hi


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.


Code: 
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)


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.


Mike.
 
NeverHappyMike

Your approach is correct

Make sure you set the color of the line and markers to none

Then select the legend and then select the series within the legend and press the Delete Key

The series will remaion on the chart and be invisible, but will be used by the chart to set the common Max and Min and will not show up in the legend

If a Gap[ appears in the legend, use the up/dn arrows to select the series and set teh series Number at teh end to either 1 or the Maximum no of series so that it is now at the top or bottom of the legend box
 
Thanks Hui. Your comments about deleting a Min/Max legend name has helped me out of a spot.


I've managed to make it work by using paste special > new series>going through and doing all the hiding, etc.


One issue I've encountered is that the Horizontal scale changes from my required scale to the new MIN and MAX scale (which is literally the words Min and Max). I've managed to revert it back to the one I want by : highlighting one of the new series and then editing it's Axis label to the original axis range of my original data. It seems to work but I'm not usre it's the most effective way of doing it.


Ah well, at least I'm moving forward.


Thanks again

Mike.
 
You must log in or register to reply here.
Back
Top