How to show Actual and Forecast on a Single Line Chart in Excel
If you have a dataset with actual values and forecasted (or projected) values, this video will show you how to display them together on the same line chart, using Microsoft Excel. There are different methods you could use, this video uses the strategy of (1) putting the Actual and Forecast numbers in two different columns, (2) creating a line chart, and then (3) using a work-around to connect the two lines.
....................................................
CHAPTERS:
0:00 Introduction
0:12 Prep the data
0:38 Create chart
2:24 Format lines
3:43 Connect the 2 lines
5:42 Closing remarks
....................................................
Video is made using Filmora.
Website: https://www.DataDesignStyle.com
Watch video How to show Actual and Forecast on a Single Line Chart in Excel online without registration, duration hours minute second in high quality. This video was added by user Data Design Style 30 May 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 6,314 once and liked it 124 people.