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" <mag7417.215uum_1136463001.5881@excelforum-nospam.com> wrote in
message news:mag7417.215uum_1136463001.5881@excelforum-nospam.com...
>
> 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
>