How do I create a bar (1-100) in exel?

[mag7417]

Hi!

My skill in excel is slowly improving but there are still a few things I need help with every now and then.

I have a column with chapter titles (Column A). In columns B, C, D there are %-ages where the total = 100%.

What I would like to do in another sheet is to displat the results in a horisontal bar in three different coulors. If column B is 35% then I would like the first 35% of that bar be, say, green. If C is 25% and D, subsequently, 40%, then I want that bar to be 25%, say yellow, and 40%, say, red.

I don't want it all in a graph, but rather in a rectangular box next to some text. I have seen it done before but don't remember how it was done. If there is a way to do what I want to do but not how I described it, then that would do too.´


Thanks in advance!

Magnus

[Jon Peltier]

Just a wild guess: what about conditional formatting?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"mag7417" <[email protected]> wrote in
message news:[email protected]...
>
> Hi!
>
> My skill in excel is slowly improving but there are still a few things
> I need help with every now and then.
>
> I have a column with chapter titles (Column A). In columns B, C, D
> there are %-ages where the total = 100%.
>
> What I would like to do in another sheet is to displat the results in a
> horisontal bar in three different coulors. If column B is 35% then I
> would like the first 35% of that bar be, say, green. If C is 25% and D,
> subsequently, 40%, then I want that bar to be 25%, say yellow, and 40%,
> say, red.
>
> I don't want it all in a graph, but rather in a rectangular box next to
> some text. I have seen it done before but don't remember how it was
> done. If there is a way to do what I want to do but not how I described
> it, then that would do too.´
>
>
> Thanks in advance!
>
> Magnus
>
>
> --
> mag7417
> ------------------------------------------------------------------------
> mag7417's Profile:
> http://www.excelforum.com/member.php...o&userid=28413
> View this thread: http://www.excelforum.com/showthread...hreadid=498241
>