How to use a single Excel stacked bar chart for multiple diverging bar charts to report variance (planning a complex chart in Excel)

One of the visuals I show in my FinancialViz courses is a multiple diverging bar chart that can show variance between actual and budget and actual and last year. This can also be used for actual and relative variances as well. I create it using a stacked bar chart and scatter with straight lines charts. This video shows you how I plan it out and the data series used. It shows how you can use advanced Excel chart techniques to create effective visuals for financial analysis and reporting.

These videos are inspired by the customized FinancialViz courses I deliver to business professionals that help them visually communicate financial results and analysis. Learn more at

By Dave Paradi

Dave Paradi has over twenty-two years of experience delivering customized training workshops to help business professionals improve their presentations. He has written ten books and over 600 articles on the topic of effective presentations and his ideas have appeared in publications around the world. His focus is on helping corporate professionals visually communicate the messages in their data so they don't overwhelm and confuse executives. Dave is one of fewer than ten people in North America recognized by Microsoft with the Most Valuable Professional Award for his contributions to the Excel, PowerPoint, and Teams communities. His articles and videos on virtual presenting have been viewed over 3.5 million times and liked over 14,000 times on YouTube.