Premium Only Content

Excel Advanced Charts: Comparison to Budget, Previous Year and Forecast or Outlook
Jan 27, 2016 Excel Charts
Complete Advanced Excel Chart Course: https://courses.xelplus.com
Written instructions: http://www.xelplus.com/companion-charts/
Excel Advanced Charts: Measuring performance, doing comparisons and predicting the future - Comparison to Budget, Previous Year and Forecast or Outlook.
Not sure which charts & methods to use to show performance and variances? This lecture will provide you with some examples that are covered in my Excel online visualization course.
Summary: This lecture provides you with an overview of different methods used for visualizing performance comparisons, deviations, as well as future estimated performance. It introduces you to the topics and charts that you will learn in this section as well as the next two sections.
This is specially beneficial for controllers and financial analysts looking to enhance their corporate reports to include better & improved charts.
Detail: In every corporate report, you have sections where you make comparison of actual values to budget or target values. In this section I will show you the most effective ways of making these comparisons.
You will also compare your performance to PY to see if you did better or worse. There are different way of doing this. My favorites are using symbols and using what I call the pin chart. I will show you these in the next section.
Lastly you will also have reports where you show how you expect to be performing for the rest of the year. These are called your forecasts or outlooks. I will show you some methods of displaying these effectively in Excel in the section after next.
One point to emphasize is the consistent use of colors in your reports. Make sure your actuals have the same colour throughout your reports. They should be clearly in focus and visible. Basically stand out against budget, target, previous year, forecasts and any other series you have.
In the same manner, be consistent with the use of color for your other series.
★ My Online Excel Courses ► https://courses.xelplus.com
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
-
LIVE
Right Side Broadcasting Network
3 hours agoLIVE: White House Press Secretary Karoline Leavitt Holds a Press Briefing - 7/17/25
8,853 watching -
DVR
Sean Unpaved
1 hour agoNo Respect for Hurts, Gillis Goes Wild, MLB Trade Deadline Buzz, & CFB's Big Question
7.35K -
1:04:54
Timcast
2 hours agoCNN SHOCKED Trump APPROVAL Went UP Following Epstein Scandal
112K79 -
LIVE
Barry Cunningham
13 hours agoMUST WATCH: KAROLINE LEAVITT HOSTS WHITE HOUSE PRESS CONFERENCE!
2,000 watching -
10:51
Adam Does Movies
2 hours ago $0.19 earnedI Know What You Did Last Summer - Movie Review
4.59K1 -
LIVE
The Tom Renz Show
1 hour agoThe DOJ Does Something! They Sue to Keep Fluoride in the Water???
232 watching -
LIVE
The Charlie Kirk Show
1 hour agoDefund NPR + New War in Syria? America's Military Restored| Ashkar | 7.17.25
2,383 watching -
LIVE
Viss
1 hour ago🔴LIVE - How to Win The Battleground with Tactics, Precision, & Knowledge!
165 watching -
1:39:35
The Mel K Show
2 hours agoMORNINGS WITH MEL K - Redefining the Threat We Face: Who are our Allies and Adversaries Really? 7-17-25
21.4K2 -
40:09
The Rubin Report
3 hours agoListen to ‘The View’ Crowd Gasp as Whoopi Melts Down Over Mark Cuban’s Mild Criticism of Dems
70.9K63