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