Chart with multiple target lines

[aklittle]

I'm trying to create a chart with multiple target lines. I've tried using error bars, but have been unsuccessful. Any thoughts on what I'm doing incorrectly? The target lines for the chart are listed in B1 and B2 of the worksheet.

excel question.xlsx
	A	B	C
1	Weekly Target	$ 577,000
2	Weekly average over trailing 36 weeks	$ 654,250	$ 575,912
3	Date	Orders Entered	Orders Shipped
4	6/5/20	$ 532,000	$ 700,000
5	6/12/20	$ 1,000,000	$ 517,651
6	6/19/20	$ 638,000	$ 460,000
7	6/26/20	$ 675,000	$ 753,745
8	7/2/20	$ 449,000	$ 681,000
9	7/10/20	$ 600,000	$ 626,000
10	7/17/20	$ 830,000	$ 600,000
11	7/24/20	$ 404,000	$ 570,000
12	7/31/20	$ 543,000	$ 709,000
13	8/7/20	$ 704,000	$ 585,000
14	8/14/20	$ 1,460,000	$ 565,000
15	8/21/20	$ 535,000	$ 719,000
16	8/28/20	$ 530,000	$ 700,000
17	9/4/20	$ 750,000	$ 830,000
18	9/11/20	$ 444,000	$ 266,000
19	9/18/20	$ 452,000	$ 473,465
20	9/25/20	$ 448,000	$ 463,000
21	10/2/20	$ 506,000	$ 700,000
22	10/9/20	$ 460,000	$ 326,000
23	10/16/20	$ 580,000	$ 390,000
24	10/23/20	$ 776,000	$ 470,566
25	10/30/20	$ 441,000	$ 885,993
26	11/6/20	$ 403,000	$ 320,000
27	11/13/20	$ 882,000	$ 493,609
28	11/20/20	$ 1,060,000	$ 500,000
29	11/25/20	$ 575,000	$ 485,595
30	12/4/20	$ 1,200,000	$ 1,100,000
31	12/11/20	$ 647,000	$ 500,000
32	12/18/20	$ 420,000	$ 600,000
33	12/24/20	$ 348,000	$ 382,000
34	12/31/20	$ 267,000	$ 585,000
35	1/8/21	$ 945,000	$ 468,000
36	1/15/21	$ 574,000	$ 472,215
37	1/22/21	$ 606,000	$ 610,000
38	1/29/21	$ 639,000	$ 775,000
39	2/5/2021	$ 1,230,000	$ 450,000
AKL Orders Entered v Shipped

Cell Formulas
Range	Formula
B2:C2	B2	=AVERAGE(B4:B39)

 

[DRSteele]

Welcome to the forum.

Do you mean like this? I simply added two data series that are nothing but the two targets repeated in each row of the data.