branston
09-06-2021, 03:42 PM
Hi
I have some data (sheet1) that is in 4 groups that I am copying on to another sheet (sheet2) in a very specific format, namely a Venn diagram format.
I have and can copy the data over by using macros and 'Named Ranges' and then placing each group in the correct section of the diagram. It's a bit long winded method but works.
The issue I am having is that the groups can become very long which means I have to MANUALLY adjust the Venn diagram and make sure enough Named Ranges / space exists before populating each 3x4 rectangle. It can become a tiresome process.
What I would like to know is :
1. Is it possible (in Excel) to create a Venn that auto-adjusts in size depending the amount of Names in each group?
2. Is there a better way / solution / software to do this e.g. Power BI?
I have included a dummy sheet (without macros) to illustrate the problem. Hopefully it's self explanatory. Can anyone help?
TIA
I have some data (sheet1) that is in 4 groups that I am copying on to another sheet (sheet2) in a very specific format, namely a Venn diagram format.
I have and can copy the data over by using macros and 'Named Ranges' and then placing each group in the correct section of the diagram. It's a bit long winded method but works.
The issue I am having is that the groups can become very long which means I have to MANUALLY adjust the Venn diagram and make sure enough Named Ranges / space exists before populating each 3x4 rectangle. It can become a tiresome process.
What I would like to know is :
1. Is it possible (in Excel) to create a Venn that auto-adjusts in size depending the amount of Names in each group?
2. Is there a better way / solution / software to do this e.g. Power BI?
I have included a dummy sheet (without macros) to illustrate the problem. Hopefully it's self explanatory. Can anyone help?
TIA