How to show Actual and Forecast on a Single Line Chart in Excel
1.9 هزار بار بازدید -
2 ماه پیش
-
If you have a dataset
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
....................................................
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
2 ماه پیش
در تاریخ 1403/03/10 منتشر شده
است.
1,936
بـار بازدید شده