Author Topic: Visio challenge - Venn Diagram  (Read 8762 times)

0 Members and 1 Guest are viewing this topic.

rsoby

  • Jr. Member
  • **
  • Posts: 14
Visio challenge - Venn Diagram
« on: March 04, 2011, 12:42:31 PM »
Most of the MS products will let you draw a circle and overlay it on another to create a Venn Diagram. And some can do 2 maybe 3 overlays where they create the size and overlay based on data. But after 3 days of web searching I can't find anything that will allow you to enter data  ( for 3+ data items) and have it draw the venn diagram.
As an example - I'm trying to build a venn that show circles relative in size to the data where the data looks like this:
 Sum of Veteran Owned Small Business Dollars     Sum of Service Disabled Veteran Owned Small Business Dollars     Sum of Small Disadvantaged Business Dollars     Sum of Women Owned Small Business Dollars     Sum of Certified HUBZone Small Business Dollars     Sum of 8(a) Procedure Dollars
 $331,923.00     $331,923.00     $331,923.00     $331,923.00     $-       $331,923.00
 $6,235,390.73     $6,235,390.73     $-       $6,235,390.73     $-       $-   
 $76,820.05     $76,820.05     $76,820.05     $-       $76,820.05     $76,820.05
 $239,029.90     $239,029.90     $-       $-       $239,029.90     $-   
 $1,504,896.72     $1,504,896.72     $1,504,896.72     $-       $1,504,896.72     $-   
 $6,164,281.04     $6,164,281.04     $6,164,281.04     $-       $-       $6,164,281.04
 $15,195,141.21     $15,195,141.21     $-       $-       $-       $-   
 $8,874,813.13     $8,874,813.13     $8,874,813.13     $-       $-       $-   
 $1,094,317.40     $-       $1,094,317.40     $1,094,317.40     $1,094,317.40     $-   
 $232,006.75     $-       $-       $232,006.75     $-       $-   
 $143,536.90     $-       $143,536.90     $143,536.90     $-       $-   
 $2,984,506.74     $-       $-       $-       $2,984,506.74     $-   
 $459,790.32     $-       $459,790.32     $-       $459,790.32     $-   
 $4,894,500.90     $-       $4,894,500.90     $-       $-       $4,894,500.90
 $27,530,894.80     $-       $-       $-       $-       $-   
 $1,066,252.65     $-       $1,066,252.65     $-       $-       $-   
 $-       $-       $3,902,160.19     $3,902,160.19     $3,902,160.19     $3,902,160.19
 $-       $-       $-       $317,075.79     $317,075.79     $-   
 $-       $-       $2,439,721.15     $2,439,721.15     $2,439,721.15     $-   
 $-       $-       $26,944,608.35     $26,944,608.35     $-       $26,944,608.35
 $-       $-       $-       $39,442,448.82     $-       $-   
 $-       $-       $7,197,776.94     $7,197,776.94     $-       $-   
 $-       $-       $5,287,768.88     $-       $5,287,768.88     $5,287,768.88
 $-       $-       $-       $-       $3,610,313.84     $-   
 $-       $-       $5,982,005.44     $-       $5,982,005.44     $-   
 $-       $-       $26,870,389.08     $-       $-       $26,870,389.08
 $-       $-       $-       $-       $-       $-   
 $-       $-       $20,381,576.82     $-       $-       $-   
 $-       $-       $-       $-       $-       $-   
 $77,028,102.24     $38,622,295.78     $123,617,138.96     $88,280,966.02     $27,898,406.42     $74,472,451.49
 $77,028,102.24     $38,622,295.78     $123,617,138.96     $88,280,966.02     $27,898,406.42     $74,472,451.49
there are six columns of data so there will be six circles
the last row is the total dollars for that column or the relative sizing for its circle
All the other rows are the over lay amounts ( realative overlay of each circle with another.

Any ideas on how to do this???

vojo

  • Hero Member
  • *****
  • Posts: 1577
Re: Visio challenge - Venn Diagram
« Reply #1 on: March 04, 2011, 01:43:47 PM »
I assume you mean Venn by row....otherwise this is more of a shotgun diagram.

I typically build either manually.....could easily make the circles scale/center  based on data (text or excell reference) via shapesheet formulas.

aledlund

  • Hero Member
  • *****
  • Posts: 1412