Venn Diagrams - automated from Access

[cbarnett]

Hi,



I'm a teacher in a secondary school and given the task of trying to automatically populate a Venn diagram with students who have different needs.

I can use Excel or Access to populate the data table and run formulae on it to put them into categories which would put them into the different areas of the diagram but not sure how to produce the report from there.

I would be very grateful if somebody has any ideas here or if I should be trying to use Excel or a mail merge with Word etc.

Any ideas?

thanks

[xps35]

I think Access is not really suitable. It is better to look for a (free) tool that is specially intended for this.

[Gicu]

Here is a link that might give you some more info:
https://www.access-programmers.co.uk...access.169740/
Cheers,

[Micron]

you can insert>smart art >illustrations in Excel to get a Venn diagram. Your data would then be in the circle textboxes.
IMO, post 10 in that link misses the mark - there is no such thing as altering the ratios of overlap areas in an effort to make these areas representative of the data. The text is all that matters. As for doing so in Access, I think your only option would be to use a control that would allow you to reproduce the diagram image. However, you'd need to create the diagram in Excel (or maybe Word) in the first place, so IMO it would be pointless to even try to get the sheet into a control. At best, I'd provide a way to open the Excel sheet from Access OR turn the diagram into an image and use a picture control in Access to contain it. Of course, it would be a static diagram in that case.