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