We help IT Professionals succeed at work.

Excel Graphic for Stage Identification

Bright01
Bright01 asked
on
350 Views
Last Modified: 2012-02-17
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
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010

Commented:
Hello,

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
CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
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.
CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010

Commented:
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.

Author

Commented:
You are the "BEST" I know of in the world of Excel Graphics/Formulas!  Thank you as always.

B.
CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010

Commented:
LOL. Thanks, Bright!
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.