Excel: Damaged y-axis charting – FM

Phrase to the smart

That is at very best a semiautomated procedure, as you wish to have to imagine:

• The more than one decided on.
• Making sure the secondary y-axis most price scales accurately (ie, I had to “freeze” the utmost price).
• Probably “tweaking” the white rectangle used for blanking out the damage.

And, sure, I’ve used dynamic arrays/Place of job 365 for a part of my answer, however that isn’t important to the process. Certainly, VBA macros might be used to automate extra of this procedure, however this is just one house of shock.

I discussed in my creation that this house divides opinion. Many spotlight the desire for handbook manipulation. However this isn’t the one explanation why: The picture generated is, somewhat frankly, misleading, albeit essentially so. It makes it more uncomplicated to learn the smaller values however understates the bigger values must finish customers simplest look on the chart.

Many consider it’s higher to create two charts — one for the smaller values and one for the bigger ones. The sense of scale is misplaced, however, somewhat frankly, it should not be relied upon on this chart in spite of everything.

Others recommend making a “Panel” chart, wherein successfully one chart is superimposed above every other to create an alternate view.

In abstract, the purpose of this text was once to turn you how to create a damaged y-axis chart, now not that you simply must. I depart that query among you, your target audience, and most significantly, your boss.

— Liam Bastick, FCMA, CGMA, FCA, is director of SumProduct, a world consultancy specialising in Excel coaching. He’s additionally an Excel MVP (as appointed through Microsoft) and writer of Advent to Monetary Modelling and Proceeding Monetary Modelling. Ship concepts for long run Excel-related articles to him at [email protected]. To remark in this article or to indicate an concept for every other article, touch Oliver Rowe at [email protected].