Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I create a bar (1-100) in exel?
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I create a bar (1-100) in exel?
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a table to qualify a qty discount in exel | New Users to Excel | |||
need to create a formula to create a timesheet but haven't a clue | Excel Discussion (Misc queries) | |||
Create a tabular control | Excel Discussion (Misc queries) | |||
Can't create dynamic charts | Charts and Charting in Excel | |||
Template in Excel | New Users to Excel |