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 (, 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?


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
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