Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Chart Colors
- Thread starter bledsoet
- Start date
For my example, I have four values in Cells A2:A5, they are 0.77,0.86,0.97,0.82 expressed as %.
In cell B2 type the formula
=IF(A2<=0.84,A2,0) and copy down to B5
In cell C2, type the formula
=IF(A2>0.84,IF(A2<=0.95,A2,0),0) and copy down to C5
In cell D2, type the formula
=IF(A2>=0.96,A2,0) and copy down to D5
Highlight B2
5, plot a stacked BAR chart.
If you need Category labels, you can type them in the worksheet somewhere, and use the source data option of the chart to change the Category names.
In cell B2 type the formula
=IF(A2<=0.84,A2,0) and copy down to B5
In cell C2, type the formula
=IF(A2>0.84,IF(A2<=0.95,A2,0),0) and copy down to C5
In cell D2, type the formula
=IF(A2>=0.96,A2,0) and copy down to D5
Highlight B2
5, plot a stacked BAR chart.If you need Category labels, you can type them in the worksheet somewhere, and use the source data option of the chart to change the Category names.
- Status
Similar threads
