How to Create a Sales Forecast Chart in Excel - Show Plan and Actual Values in the Same Line
Welcome to our tutorial on How to Create a Sales Forecast Chart in Excel using the fastest way.
🎓 LEARN MORE in my Excel tutorials: https://exceldashboardschool.com/
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
🎁 SHARE this video and spread the Excel love.
Chapters:
00:00 Intro
00:07 How to Create a Sales Forecast Chart in Excel
It's a common problem to show two data series on a single-line chart. First, split the actual and the forecasted values into two columns. The main point is that you can use this row to join the two series. It is important that In these cells, the two values should be equal. Select the entire range from B2 to D19 to create the chart. Locate the Insert Tab on the ribbon, then insert a line chart. Now apply custom formatting for the forecast series. You can change the line colors and the line styles. The result looks great.
#excel #exceltips #exceltutorial
