Conditional colors for bars in a chart???

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

Hi

here's some material to do it:

http://peltiertech.com/Excel/Charts/...nalChart1.html


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Meenie" wrote:

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

Thank you, Wigi, but I'm afraid that was completely Greek to me
sigh

"Wigi" wrote:

Hi

here's some material to do it:

http://peltiertech.com/Excel/Charts/...nalChart1.html


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Meenie" wrote:

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

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.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Meenie" wrote:

Thank you, Wigi, but I'm afraid that was completely Greek to me
sigh

"Wigi" wrote:

Hi

here's some material to do it:

http://peltiertech.com/Excel/Charts/...nalChart1.html


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Meenie" wrote:

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

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

"Wigi" wrote:

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.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Meenie" wrote:

Thank you, Wigi, but I'm afraid that was completely Greek to me
sigh

"Wigi" wrote:

Hi

here's some material to do it:

http://peltiertech.com/Excel/Charts/...nalChart1.html


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Meenie" wrote:

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

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 :/

"Meenie" wrote:

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

"Wigi" wrote:

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.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Meenie" wrote:

Thank you, Wigi, but I'm afraid that was completely Greek to me
sigh

"Wigi" wrote:

Hi

here's some material to do it:

http://peltiertech.com/Excel/Charts/...nalChart1.html


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Meenie" wrote:

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

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

"Meenie" wrote:

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 :/

"Meenie" wrote:

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

"Wigi" wrote:

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.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Meenie" wrote:

Thank you, Wigi, but I'm afraid that was completely Greek to me
sigh

"Wigi" wrote:

Hi

here's some material to do it:

http://peltiertech.com/Excel/Charts/...nalChart1.html


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Meenie" wrote:

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

Thanks for letting us know.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Meenie" wrote:

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

"Meenie" wrote:

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 :/

"Meenie" wrote:

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

"Wigi" wrote:

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.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Meenie" wrote:

Thank you, Wigi, but I'm afraid that was completely Greek to me
sigh

"Wigi" wrote:

Hi

here's some material to do it:

http://peltiertech.com/Excel/Charts/...nalChart1.html


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Meenie" wrote:

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