Hello Excel community.
I am looking for some help about conditional formatted Excel column Chart. I am looking for a chart example For company A , at0:00: 2% were late, at 1:00:00 2.25% were late. The threshold is 10%. By using conditional formatted excel column chart i have been able to set Company A that is the column chart above 10% is red and then below 10% is green.
The issue i am having is when i need to include company B and company C on the same graph using the conditional formatted. Any idea how can i process this
Thank you
I am looking for some help about conditional formatted Excel column Chart. I am looking for a chart example For company A , at0:00: 2% were late, at 1:00:00 2.25% were late. The threshold is 10%. By using conditional formatted excel column chart i have been able to set Company A that is the column chart above 10% is red and then below 10% is green.
The issue i am having is when i need to include company B and company C on the same graph using the conditional formatted. Any idea how can i process this
Thank you
| Time HR | Company A - Lateness | Company B- Lateness | Company C - Lateness |
0:00:00 | 2.00% | 1.25% | 4.00% |
1:00:00 | 2.25% | 4.50% | 2.35% |
2:00:00 | 3.50% | 2.25% | 2.45% |
3:00:00 | 1.50% | 1.35% | 3.65% |
4:00:00 | 4.50% | 5.30% | 1.25% |
5:00:00 | 0.10% | 14.29% | 1.36% |
6:00:00 | 1.45% | 2.25% | 12.00% |
7:00:00 | 6.08% | 28.57% | 14.00% |
8:00:00 | 8.78% | 14.29% | 16.00% |
9:00:00 | 13.61% | 10.50% | 8.00% |
10:00:00 | 13.51% | 12.50% | 9.00% |
| Company A -Lateness | Company B- Lateness | Company C- Lateness | |
| Target Set | >10 | >5% | >5% |
