Conditional colors for bars in a chart???


G

Guest

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
 
Ad

Advertisements

G

Guest

OK. Message understood ;-)

Here are the basics. Go to my website, http://www.wimgielis.be, then choose
Excel in the left navigation, then choose Voorbeeldbestanden, then choose
Kleurenstaafdiagram (it's under "Excel grafieken")

Download the example file on that page.

1 final thing: "afkapgrens" means "cut-off value": below that, it colours
red, above: green.
 
G

Guest

Hmmmm.... well, that wasn't Greek, I'll give you that :)
Let me tell you what I've managed to do so far.
I can make a nice plain graph.
Down the left side it has 100 at the top and drops by 10 down to 10.
Across the bottom it has each units name (3A, 4A, 4E, 5E, etc - there's 11
of them)
Nice Graph :)
But what I want to do is change the color of the bars so that if it is at
100 it's green
If between 80 and 100 it's yellow
If below 80 it's red.
I discovered if I did "show legend" then right click inside the graph and
click on "source Data" and change the Data Range to Columns instead of Rows,
I can change the legend key for each one to whatever color I want.
UNFORTUNATELY, when I do this it wipes out my unit names on the bottom and I
can't get them back unless I change my Data Series back from columns to rows.
.. . then I lose my colors.
Jeepers, I'm confused with this thing. :(
Granted, what I'm trying to do is manual - ie: I would have to change the
colors manually each month but that's ok. But I can't seem to have my cake
and eat it too. I can have colors and no labels, or labels and no colors....
<sigh>
Meenie
 
G

Guest

OK color me goofy, but I almost answered my own question :)
I changed my date from rows into columns (just copied/paste special/transpose)
Now I can change the colors and have the names, but I still get this number
1 at the bottom.
Anyone know how I can get rid of that?
I hid the legend and the "1" appeared.
Thanks :/
 
Ad

Advertisements

G

Guest

Ohhhh for heaven's sake...
If I get insane enough I seem to find a way LOL
I figured the problem out... just had to click on the axis, click Format
Axis, to to Patterns tab, and click NONE in the Mark Ticks area.
Nothing difficult about that, huh?
I guess they could have written it in Japenese or Bangladesh or something....
sheesh <grumble grumble>
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top