Good afternoon. I was really hoping someone could help me out. We're trying to create a simplified and interactive interface to show our staff's metrics. The metrics are grouped into three main categories and as they get closer to hitting their goal, the closer the Venn area gets to the 0, 0 xy.
What my boss' boss is looking for is to see if there is ANY WAY I can shade the inside of the Venn area (where all 3 circles converge), or, shade every other than the venn area?
I've attached the workbook (excel 2010) and would really appreciate any help I could get. Thank you.
In principle, it should be possible to add small shapes to the graph to give a polka dot effect where the individual XY coordinates are simultaneously within all three circles.
Martin
Eighty Twenty Spreadsheet Automation http://homepage.ntlworld.com/martin.rice1/ for all your Excel customisation and consulting needs.
If my solution has saved you time and/or money, please consider donating to Cancer Research UK.
mrice,
I'm not sure how to do that. Could you please elaborate?
You can use another series to hold copies of transparent shapes.
The shapes will move the xy locations but they will not resize if the radii changes.
Attached is a rather crude proof of concept. The code in Module1 (alt F11) tests each point on an imaginary grid on the graph for whether it is in all of the circles and therefore within the intersection. A small circle is placed there if this condition is satisfied.
It is necessary to define the formuale of the circles for this to work - I've hard coded this in the example.
Martin
Eighty Twenty Spreadsheet Automation http://homepage.ntlworld.com/martin.rice1/ for all your Excel customisation and consulting needs.
If my solution has saved you time and/or money, please consider donating to Cancer Research UK.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks