I have to color code bars on a chart based on specific conditions. For example: For sites that have more than three outages a month, I need to color code those bars red. Else, green. I can't seem to find where I can place a formula to do this. If I use a text box behind the chart, the bars will not match. Sometimes there can be 10 sites and sometimes 20. It's different every time I run the report. And only the sites with outages are refected on the report. They are different every time the report is run also. Has anyone any ideas on what I could do to color code these bars. Thank you.
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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Where to place formula to Conditionally color fill bars of a chart 1
- Thread starter mhansler
- Start date
-
1
- Thread starter
- #2
Found it.
IN CR9 right click on the chart and go into chart expert, then the options tab. If you do not see the options tap, uncheck "Automatically format this chart" and the options tab will appear. The first option is chart color. Click on the format button. Here you can build all your conditional color formatting.
IN CR9 right click on the chart and go into chart expert, then the options tab. If you do not see the options tap, uncheck "Automatically format this chart" and the options tab will appear. The first option is chart color. Click on the format button. Here you can build all your conditional color formatting.
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question