Excel Graphic for Stage Identification
EE Professionals,
I'm looking to create a graphic that identifies a specific "level" or Stage. Attached you will find a WS that has a picture of what I'm trying to accomplish from a simple graphics point. If the value is "1" then it's a solid black ball. If "0" it would be white fill. I've tried to use condition formatting but it's not working out well. Lines need to extend from one "Stage" to the next, as shown by the diagram to the right in the WS.
Seems like a simple exercise for someone who knows graphics in Excel.
Thank you in advance,
B.
Stage-Determination-Chart.xlsm
I'm looking to create a graphic that identifies a specific "level" or Stage. Attached you will find a WS that has a picture of what I'm trying to accomplish from a simple graphics point. If the value is "1" then it's a solid black ball. If "0" it would be white fill. I've tried to use condition formatting but it's not working out well. Lines need to extend from one "Stage" to the next, as shown by the diagram to the right in the WS.
Seems like a simple exercise for someone who knows graphics in Excel.
Thank you in advance,
B.
Stage-Determination-Chart.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Teylyn,
Wow.... actually looks very good! One slight issue. If you change the 1 or 0 in the cell, you get a replication of the "Stage". Can you take a look? Not sure why it's adding an additional header in the "Stage" cell.........
Much thanks.....and again, except for that, it looks very good!
B.
Wow.... actually looks very good! One slight issue. If you change the 1 or 0 in the cell, you get a replication of the "Stage". Can you take a look? Not sure why it's adding an additional header in the "Stage" cell.........
Much thanks.....and again, except for that, it looks very good!
B.
Peculiar. I see that, too. But it's not content. It's a rendering issue. Scroll down, so the cells disappear from the screen, scroll up again and the "shadow" text is gone.
Could be a bug.
Could be a bug.
ASKER
You are the "BEST" I know of in the world of Excel Graphics/Formulas! Thank you as always.
B.
B.
LOL. Thanks, Bright!
you can create this effect using the Wingdings2 font with the character codes 152 and 153
Format a cell with Wingdings2. Hold down the Alt key and on the numberpad enter 0152. Do the same for 0153. These are the dots.
The character code 0151 in Arial has a nice, wide line.
Combine these into neighbouring cells, center horizontally and vertically in each cell. Adjust the column widths. Then use a simple IF statement to determine if the data entered in a separate cell evaluates to 1 or 0.
See attached.
cheers, teylyn
Stage-Determination-Chart.xlsm