Method A:  Conditional Formatting Column Charts & Labels

Method B: Excel Better Variance Charts with Error Bars

Method C & D: Variance Charts with Dynamic Arrows

Download the Variance Chart Workbook HERE:

Free Excel Download for Variance Charts

Leila Gharani

I'm a 6x Microsoft MVP with over 15 years of experience implementing and professionals on Management Information Systems of different sizes and nature.

My background is Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert, SAP BW Project Manager. My passion is teaching, experimenting and sharing. I am also addicted to learning and enjoy taking online courses on a variety of topics.