How to do mathematically accurate Venn diagrams in Excel 2007

Question: How to do mathematically accurate Venn diagrams in Excel 2007 (as distinct from the ones in Smart Art)

Answer:  Widely discussed question on the web – there doesn’t appear to be a plug in for this

Looked in the Office Marketplace but couldn’t find anything close (The office marketplace also lacks decent search tools, so I might have missed it…)

There is an article on mathematically accurate Venn diagrams – which details building them up step by step at http://blog.data-miners.com/2008/10/creating-accurate-venn-diagrams-in.html

I haven’t tried it – but it looks like it would work.

Steven

How big can a PDF be? / How do I read an Article in a PDF?

Q1. How big can a PDF be?

A. I haven’t found a reference to a maximum size.  Your ability to generate a PDF may be limited by your system resources. Continue reading “How big can a PDF be? / How do I read an Article in a PDF?”

Page Breaks in an existing PDF

Q. System XYZ outputs reports as a PDF – but the page breaks are in awkward places – can we add a page break to the existing PDF? Continue reading “Page Breaks in an existing PDF”

Excel Charts – Small and Large values on the same axis

This is a question that came up recently. My first thought was add a secondary axis, but in this case the small and large values were in the same series. I thought there might be something available as a third party add-in for Excel.

Solutions to Try

I did find an answer by Jon Peltier which looks good and gives step by step detail, but also appears to be a lot of work. This article provides links to alternative approaches at tushar-mehta.com and andypope.info – which has a zipped example to look at. If you are seriously  into graphs you should visit Jon Peltier’s blog. Continue reading “Excel Charts – Small and Large values on the same axis”