How to Create a Step Chart in Excel

Advantages of using a Step Chart in Excel

Step 1: Create your Data Table

In this article, we’ll make a Step Chart based on the Bitcoin Prices over a few weeks. So, let us create our data table first.

Note: In this article we are using MS Excel 2010, but above steps are valid for all the latest versions.

Step 2: Re-arrangement of data

Now, once your data is ready, make two more empty columns with the same titles adjacent to the ones you just made.

Now, select all the cells from A2 till the end of your column (in this case A18) and press Ctrl + C, to copy it. Then, paste it in the new DATE column. Similarly, copy from the FIRST element of the BTC PRICE column to the second last element and paste it into the new BTC PRICE column. The final result will look like this.

Now, copy all the elements from both the old columns and paste them right under the new columns as shown below.

Part 1

Part 2

Step 3: Conversion to Step Chart

Select both the new columns entirely and go to Insert. Locate the Line Chart under the Charts section and click on it.

Now, wait for the chart to show up, and you’ll be all set!