HI :)
I'm new to making charts and don't know if this is possible. Here's what I'm
doing. I am tracking compliance between units in a hospital for patient
falls.
Then I am charting each question to show the comparison percentages.
It's a simple bar chart that shows each unit and what it's percentage is.
I have the numbers for each unit with conditional formatting so if their
total is 100 %, the background color is green, between 80 and 90 it's Yellow,
and below 80 it's Red.
I'd like the bars to corrospond. Is that possible. I found how to make them
different colors, but I can't control the colors.
Is it doable?
Keep in mind, I'm new to charts and don't understand all the jargon.
Thanks! :)
Meenie