Graphing with forecasted data as a different color

[ScienceGirl55]

I have a data table with month-year in column A and values in column B. I want these in a simple line graph where excel knows that the line is dark blue from Jaunary 1 through todays date and then continues from the day after today to December 31 (same year) as light blue. The idea is to show that on any given day the data up to today is actual and the data from tomorrow through the end of the year is a forecast. (could also be dark blue actual and dark blue dashed for forecasted - whatever works).

 

[awoohaw]

How about creating two lines, one for actual, and one for forecast,repeating the last month of actual on the month forecast begins:

WorkBook1.xlsx
	A	B	C	D
2
3		Actual	Forecast
4	1/1/2023	12
5	2/1/2023	12
6	3/1/2023	14
7	4/1/2023	20
8	5/1/2023	21	21
9	6/1/2023		20
10	7/1/2023		14
11	8/1/2023		14
12	9/1/2023		19
13	10/1/2023		16
14	11/1/2023		17
15	12/1/2023		15
16
17
18
Sheet2

 

[awoohaw]

@ScienceGirl55 , did you find an answer to this?

 

[ScienceGirl55]

@ScienceGirl55 , did you find an answer to this?

Yes! Thanks!