Chart Bars

  • Thread starter Thread starter Shahzad
  • Start date Start date
S

Shahzad

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
 
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($B3>C$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
 
Back
Top