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) |
