Chart with multiple target lines

aklittle

New Member
Joined
Feb 12, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
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
ABC
1Weekly Target $ 577,000
2Weekly average over trailing 36 weeks$ 654,250$ 575,912
3DateOrders EnteredOrders Shipped
46/5/20$ 532,000$ 700,000
56/12/20$ 1,000,000$ 517,651
66/19/20$ 638,000$ 460,000
76/26/20$ 675,000$ 753,745
87/2/20$ 449,000$ 681,000
97/10/20$ 600,000$ 626,000
107/17/20$ 830,000$ 600,000
117/24/20$ 404,000$ 570,000
127/31/20$ 543,000$ 709,000
138/7/20$ 704,000$ 585,000
148/14/20$ 1,460,000$ 565,000
158/21/20$ 535,000$ 719,000
168/28/20$ 530,000$ 700,000
179/4/20$ 750,000$ 830,000
189/11/20$ 444,000$ 266,000
199/18/20$ 452,000$ 473,465
209/25/20$ 448,000$ 463,000
2110/2/20$ 506,000$ 700,000
2210/9/20$ 460,000$ 326,000
2310/16/20$ 580,000$ 390,000
2410/23/20$ 776,000$ 470,566
2510/30/20$ 441,000$ 885,993
2611/6/20$ 403,000$ 320,000
2711/13/20$ 882,000$ 493,609
2811/20/20$ 1,060,000$ 500,000
2911/25/20$ 575,000$ 485,595
3012/4/20$ 1,200,000$ 1,100,000
3112/11/20$ 647,000$ 500,000
3212/18/20$ 420,000$ 600,000
3312/24/20$ 348,000$ 382,000
3412/31/20$ 267,000$ 585,000
351/8/21$ 945,000$ 468,000
361/15/21$ 574,000$ 472,215
371/22/21$ 606,000$ 610,000
381/29/21$ 639,000$ 775,000
392/5/2021$ 1,230,000$ 450,000
AKL Orders Entered v Shipped
Cell Formulas
RangeFormula
B2:C2B2=AVERAGE(B4:B39)
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,358
Office Version
  1. 365
Platform
  1. Windows
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.


1613168292978.png
 

Watch MrExcel Video

Forum statistics

Threads
1,128,132
Messages
5,628,892
Members
416,352
Latest member
Lunox01

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top