Hi all,
I have a chart with high-low lines showing the difference between 2 series, however there are 3 series on the chart. At times, the 3rd series becomes the greatest value, however i only want the hi-lo lines and valuse to represent the difference between the 2 set series of data (ie if the 3rd series is the max or min value I want it ignored)
I can show the data labels no probelm as only the difference between the 2, however visually the hi-lo lines still show all the way to the 3rd series. Can they be locked to only go to 2 of the data sets?
See attached file ... the data i want the lines to show is the difference between the red and Yellow lines, ignoring if the green line goes higher or lower than the others.
Bookmarks