Advice of Chart Design

[JeffGrant]

Hi All,

I have data that looks like this:

Yes High	Yes Low	Yes Close	No High	No Low	No Close
		0​	92​	25​	25​
58​	25​	25​			0​
56​	22​	22​			0​
		0​	58​	25​	25​
		0​	60​	20​	20​
86​	14​	14​			0​
		0​	67​	17​	17​
		0​	80​	20​	20​
71​	14​	14​			0​
60​	20​	20​			0​
25​	13​	13​			0​
75​	13​	13​			0​
56​	22​	22​			0​

Where there is 2 sets of Hi-Low Data.

However, only one set is valid on each row. ie, for that row, the Hi_Low is either a YES value or a No value.

Idealy an Excel Stock Hi-Low chart is excellent for this data.

I can chart one set of data easy enough with the Stock Hi-Low chart by adding an extra column as the Low=Close value. (not the best but is ok)

However, how can I add the second set of NO data on the same graph and then choose a different colour for the different data sets.

Or am I wanting something that is a bit too diffiuclt and I need to rethink what I am doing ???

My Appologies if I sound a bit naieve on his one

Thanks in advance

 

[JeffGrant]

Update...my main issue is that if I add the two data sets onto the same chart, that excel thinks that the two sets combine and then I can't change the colour to differentiate between them.

 

[JeffGrant]

Not resolved.
Using a Hi-Lo-Close chart would suffice. Would have been nice to have a better looking chart, but it is not mandatory.
Using the traditional index/match on a table gives me the numbers I need anyway.