You have looked at the difference between the actual and budget expenses in the different expense categories. You want to communicate the variances visually. This video shows how to use a steps to a total column graph to show the actual expenses and variance in each category and how they add to the total expense amount.
I learned the trick for two-level category labels from this article by Cole Nussbaumer Knaflic.
For more on creating dotted or dashed lines to compare to columns, see this video: https://youtu.be/L09E3y_N-no
Want to learn more?
See more examples of visuals to use when presenting financial statements, results, or analysis
Read about visuals that work when presenting the Income or Profit/Loss statement, Balance Sheet, and Cash Flow Statement
Get training to improve your skills at creating effective financial visuals
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.