Hi,
You will need to use 3 series to build the stack. Simplest way is to use a
cluster chart, setting the overlap value to 100, with data base on formula.
If you have the following data in A2:B9
A2: =<leave empty B2: =SeriesName
A3: =A B3: =0
A4: =B B4: =1
A5: =C B5: =2
A6: =D B6: =3
A7: =E B7 =4
A8: =F B8: =5
A9: =G B9: =6
You can then create the following formula to create chart data.
C1: =6
D1: =4
E1: =2
C2: =Blue
D2: =Green
E2: =Red
C3: =IF($B3C$1,C$1,$B3)
Drag C3 across and down the range C3:E9
Now create your chart on the range $A$3:$A$9,$C$2:$E$9
Format the columns to match colour descriptions. Set Series Options
Overlap =100
Cheers
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Shahzad" wrote in message
...
How to create intersectionso if the hight of bar crosses that line the
color
of the bar should from that point.
From Level 0 - 2:- RED Color
From Level 2 - 4:- Green color
From Level 4 - 6:- Blue color