troubleshooting Question

Use VBA to modify "Pie" shape/color

Avatar of ExpExchHelp
ExpExchHelpFlag for United States of America asked on
Microsoft Excel
6 Comments1 Solution774 ViewsLast Modified:
In a previous thread (https://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28184618.html), both experts byundt and rorya have provided fanstastic assistance with a ~90% solution.

However, as the thread grew in length -- and it eventually turned into somewhat of another subject -- it makes sense to now start a new question now.

** Break **

Please see attached XLS for details.   Here's the scoop on it.

1. On tab "Shape", there are four data entry cells (E15:E18).
2. The "Notes" area (starting in cell K14) illustrates the four "pie" shapes.  Their angles are currently driven by two (2) adjustment variables in the VBA code.   The angles/shapes work great... no additional work is required.
3. Right now, only one shape/pie is shown in cell area E1 through F4 (approximately)

What's needed:
- Zone 1 should be linked to bottom left pie (currently red).
- Zone 2 should be linked to bottom right (currently in yellow)
- Zone 3 should be linked to top right (currently in yellow)
- Zone 4 should be linked to top left (currently in green).

(Btw, order of these can be changed... I chose counter-clockwise right now...).

- Basically though, I'd like to display all four shapes together... mimicking an oval/egg-shaped display.  
- The top two pie should be slightly larger (maybe even twice as large) as the bottom two shapes.  
- Most importantly though, the values in E15:E18 should drive their individual colors.   So, basically following a stopo-light principle.

Again, please see attached XLS for details.

Does anyone know how to accomplish this?

Thanks,
EEH
Pie-Shape.xls
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 6 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros