Results 1 to 15 of 15

Generate Venn diagrams with multiple data

Threaded View

  1. #15
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Generate Venn diagrams with multiple data

    Hi Yogesh,

    Here's the code - once you have the calculations, just run it from 3 to 5!

    Sub VennEm(): Dim s As Integer, i As Long, j As Long, Origin As Range
    Dim R As Single, X As Single, Y As Single, OL As Single, OT As Single
    Dim L As Single, T As Single, W As Single, H As Single
    
    Set Origin = Range("K17"): OL = Origin.Left: OT = Origin.Top: s = 10
    
    For i = 3 To 5
    R = CSng(Range("C" & i) / s): X = CSng(Range("H" & i) / s): Y = CSng(Range("I" & i) / s)
    L = OL + X - R: T = OT - Y - R: W = 2 * R: H = 2 * R
    
    Call VC(L, T, W, H)
    
    Next i
    End Sub
    *the rest of the system is in the workbook post #9
    Last edited by xladept; 06-12-2015 at 03:39 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1