| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do I get the bars on my graph to match the cell color
I have conditional formats on cells so that a color is generated based on
what number is in the cell. When I make a simple bar graph, the data series is all one color. Without having to change each bar individually is there a quicker way of doing this? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
how do I get the bars on my graph to match the cell color
Hi,
See Jon Peltier's page on conditional charts. http://peltiertech.com/Excel/Charts/...nalChart1.html You will need to apply the same CF formula to the chart data. Cheers Andy kwazy4 wrote: I have conditional formats on cells so that a color is generated based on what number is in the cell. When I make a simple bar graph, the data series is all one color. Without having to change each bar individually is there a quicker way of doing this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference Cell Color From Other WorkSheets | Excel Worksheet Functions | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Color a cell and a value is automatically assigned to that color. | Excel Worksheet Functions | |||
Hybrid Mode
