i want to create harvey balls in excel. i thought i had seen it done before
using 0-4 to give you the circle to the fully colored in circle.

here's a link to a thread about harvey balls in powerpoint w/
shapes.......
maybe you can modify?
http://www.pcreview.co.uk/forums/thread-930213.php

& here's a link for a download for some........
http://www.soniacoleman.com/FAQs/FAQ00197.htm

now that i know what they ARE, i'm going to experiment over the
weekend & see what i can come up with (if anything).
hth
susan


On May 18, 1:11 pm, rob wrote:
i want to create harvey balls in excel. i thought i had seen it done before
using 0-4 to give you the circle to the fully colored in circle.

Try making a pie chart and see if that's what you want.


"rob" wrote:

i want to create harvey balls in excel. i thought i had seen it done before
using 0-4 to give you the circle to the fully colored in circle.

rob -
i did look @ this this weekend, but i forgot to bring the spreadsheet
to work. :(
the best thing i could come up with is:

in excel 2003, if you insert an autoshape, & choose "other
autoshapes", there was a pieslice autoshape.
in excel 2000, i found it under the "miscellaneous" folder of extra
clips it brings up.

it's a "wmf" file, & the name in the properties is "BD18235_"

anyway, the pieslice has two open sides at 12pm & 3pm, which are
moveable. i recorded a lot of macros trying to decipher how you can
make the movements exactly to 12pm, 3pm, 6pm & 9pm. i also
experimented with adding a flowchart "OR" shape behind it, colored
white with no lines, to make sure it was a black & white harvey ball;
however, the OR shape is not exactly circular, & i couldn't get it to
work exactly right.

but in theory, the idea might work. enter an OR shape, color it
white, make lines white, then add a pieslice shape on top of it, &
adjust the "arms" to point where you want.

if you get it to work, i would greatly appreciate your posting the
code! and so will anybody else looking for harvey ball programming in
the future!
hope it helps
susan




On May 18, 1:11 pm, rob wrote:
i want to create harvey balls in excel. i thought i had seen it done before
using 0-4 to give you the circle to the fully colored in circle.