How to make a step chart in excel

Quick, manual method. Make two copies of the same values. Delete the first date and the last number from one set of values and line them up. Then plot the whole table as a line chart to make a step chart.

Note: If this doesn't work for you try changing the x-axis options from text to date.
---------------------------------------------------------------------------------
#exceltips #exceltutorials #excelcharts

Microsoft Office 365, Beta Channel, Version 2103
---------------------------------------------------------------------------------

[mudden]

It does not work :(
During the first 8 seconds of this video "Select everything and select insert chart". I follow the steps, selects my data, but get two separate lines... One orange line and one blue line. How do I get just one line??

[chinmaykeskar]

I could not get this either. But figured that I needed to choose "scatter chart" (and not line chart) and then "sort" at the end from oldest to newest to make this work. Thanks.

[baibadirnena]

Fun fact, it does not work with other formats (numbers or letters), only dates. Had to redesign my data set, but it turned out awesome. Thanks! :)

[rickardk]

really! This saved me so much! thank you!!! this was PERFECT!!!! <3

[fragranceenthusiast]

Wow! I love an Excel quickie from you, specially one as good as this. Keep up the top Excel tutoring! Thank you Katrina :0)

[jaoMartins]

Thanks a lot!! It Works perfectly, I don't really get it how, but it does the job!