Skip to content
Related Articles

Related Articles

Improve Article

Step Chart in Excel

  • Last Updated : 15 May, 2021

A step chart is used to represent data that changes irregularly between time intervals. Now, Excel doesn’t have a feature to create a Step Chart like the one shown below but we can create one by making some changes in our data.

Steps for creating a Step Chart in Excel

Step 1: Creating 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: This article makes use of Microsoft Excel 2010, but all steps are valid for all later 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 till the second last element and paste it in 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!

My Personal Notes arrow_drop_up
Recommended Articles
Page :