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