How to Create an Excel Step Chart

A step chart is a great way to show how there has been a significant increase at a period of time.  When simply using a line chart in Excel the data is naturally going to trend from one point to the next.  This action creates a slope. As opposed to, a stepchart that will show a literally step from point to point.  Let’s take a look at the different.

 A step chart is composed of two vaules that exist at the same point.

What is the difference between a line chart and a step chart

Line Chart

As you can see in the line chart is composed of a single value at a period of time.

Step Chart

A step chart is composed of 2 values at a single point in time.

How to Make a Step Chart

So in order to make a step chart, you need to create two values at a certain date. Let’s follow the instructions below or check our video:


Create a second data table:

  1. Copy the headings of existing table data to create a second table.
  2. Move one space down, leaving one empty space between your heading and next data point.
  3. Use the second date in our data and add the first value in your data.
  4. Copy the data down by double-clicking plus sign or dragging the data down.
  5. Now copy your original data and paste it under the second data table.
  6. Highlight your new second table and insert a line chart.

Insert the first date and the second value

Take the second date and the first value

copy your data from the second table

Copy the data down into the end of the first data set.

Copy the original data from the table to the second table to make a step chart

Once you have the copied data. You have two points at a single point in time which creates a step.

Gaelim Holland

Subscribe
Notify of
guest

0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments