| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Bar Chart
I have created a bar chart for my manager which he is quite happy with, but
now I have been asked whether it is at all possible to apply a colour to each bar depending on whether it is equal to certain criteria, a bit like the conditional format facility. I am currently using Excel 2002. The criteria I want to use is if the figure is 8.7 I would like the bar in the chart to be red. 8.3<8.7 orange, 7.8<8.2 yellow and 7.7 or less green. I would also like these figures to appear in an appropriate coloured square in the legend. TIA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003: How to nudge a chart element or shape on a chart? | Charts and Charting in Excel | |||
| Chart Titles not showing in excel chart | Excel Discussion (Misc queries) | |||
| Chart Titles not showing in excel chart Window | Excel Discussion (Misc queries) | |||
| Excel chart - how to assign the file name in the chart title? | Charts and Charting in Excel | |||
| How do I resize a chart in Excel after the chart has been saved... | Charts and Charting in Excel | |||
Threaded Mode
