Make a score worm

[bomberswarm2]

What I want to do is make a chart like this:

That shows score and when they happen. So a team score a goal at the 3 minute mark, their margin goes up 6 points, then a point at the 5 minute mark, they go up to 7 points, then at the 14 minute mark the other team scores a goal and it goes back to 1 point margin, at the appropriate time on the timeline.
Is there any way to do this in excel?

 

[thisoldman]

The chart is called a step chart. You can find a tutorial by Jon Peltier at: https://peltiertech.com/Excel/ChartsHowTo/StepChart.html

 

[bomberswarm2]

The chart is called a step chart. You can find a tutorial by Jon Peltier at: https://peltiertech.com/Excel/ChartsHowTo/StepChart.html

that is way too complex i can't understand any of it after 'The Data' is there a noob version that dosen't need 400 formulas?

 

[thisoldman]

Here's a take of Jon Peltier's method that includes a video: https://trumpexcel.com/step-chart-in-excel/

 

[bomberswarm2]

Here's a take of Jon Peltier's method that includes a video: https://trumpexcel.com/step-chart-in-excel/

Tried it and it dosen't work.

 

[thisoldman]

Excel does some strange things with charts depending on the header cells. I think I can straighten this out/

Delete the contents of cells D1:E1.
In E2, type "Margin".

Select D2:E35 and insert a line chart–the chart looks ugly.
Select the chart horizontal axis and Format it as a Date axis.

You should now have a step chart.