how do i create harvey balls?
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. |
how do i create harvey balls?
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. |
how do i create harvey balls?
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. |
how do i create harvey balls?
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. |
All times are GMT +1. The time now is 03:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com