Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Bars
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Bars
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Customise error bars on individual bars in a bar chart 2007 | Charts and Charting in Excel | |||
how do I get more than 19 bars on a bar chart | Charts and Charting in Excel | |||
Help with bars in bar chart | Charts and Charting in Excel | |||
2 Bars and 2 Y Axis Chart | Charts and Charting in Excel | |||
Bars in a chart??????? | Excel Worksheet Functions |