| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
format colors on bar charts by value
I'm working on a Bar chart with 5 bars. What I would like to do is change
the color of each bar depending on the number it is graphing. My table is very simple, column A is the data names, column B are the values from 0 to 3. If the value is 1 I would like it to change the color of the bar to red, if it is 2 I'd like it to change to yellow, if it is 3 I'd like it to change to green. Can this be done? Thanks Bill |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Colors for Charts | Charts and Charting in Excel | |||
| Conditional Colors for Charts | Charts and Charting in Excel | |||
| Matching the colors Column Charts and Pie Charts | Charts and Charting in Excel | |||
| Can't format font colors or cell fill-in colors | Excel Discussion (Misc queries) | |||
| Changing Colors in Bar Charts | Excel Worksheet Functions | |||
Threaded Mode
