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”