asked on
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
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.
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.