Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Graphic Indicator
In MS Project there is a "graphic indicator" that allows text to be
graphically represented. e.g. Yes = Green Dot, No= Yellow Dot, Maybe=Yellow Dot. It would be beneficial in EXCEL to have this ability. I want to use the grid that EXCEL provides so Charting won't help. I'd like for this graphic representation to be in just one column of several columns of important text and numeric content. I can't think of a way to get a graphic into an IF statement, or is there some other way to do this. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Graphic Indicator
Have you tried clicking on "Insert" in the menu bar, then "Symbol".?
Patricia Shannon "WTPB041" wrote: In MS Project there is a "graphic indicator" that allows text to be graphically represented. e.g. Yes = Green Dot, No= Yellow Dot, Maybe=Yellow Dot. It would be beneficial in EXCEL to have this ability. I want to use the grid that EXCEL provides so Charting won't help. I'd like for this graphic representation to be in just one column of several columns of important text and numeric content. I can't think of a way to get a graphic into an IF statement, or is there some other way to do this. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Graphic Indicator
WTPB041 Wrote: In MS Project there is a "graphic indicator" that allows text to be graphically represented. e.g. Yes = Green Dot, No= Yellow Dot, Maybe=Yellow Dot. It would be beneficial in EXCEL to have this ability. I want to use the grid that EXCEL provides so Charting won't help. I'd like for this graphic representation to be in just one column of several columns of important text and numeric content. I can't think of a way to get a graphic into an IF statement, or is there some other way to do this. Hi WYPBO41, A lower case L in Wingdings font displays a solid circle. and A lower case n in Wingdings font displays a solid circle. With Conditional Formating you can set up to three conditions with different background and font colors, for coloring them. -- Desert Piranha ------------------------------------------------------------------------ Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934 View this thread: http://www.excelforum.com/showthread...hreadid=512399 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
format comment indicator | Excel Discussion (Misc queries) | |||
Ability to change the Excel comment indicator color | Excel Worksheet Functions | |||
Graphic depiction of an "either-or" (0 or 1) indicator | Charts and Charting in Excel | |||
Different graphic for each record in mail merge document | Charts and Charting in Excel | |||
Graphic in Header scaling with pages contents | Excel Discussion (Misc queries) |