How to Create a Step Chart in Excel
Last Updated :
25 Sep, 2023
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.
What is a Step Chart in Excel
A Step chart is the same as a Line Chart. The step Chart does not use the shortest path to connect two data points. It instead uses vertical and horizontal lines to connect the data points to form a step-like progression. The vertical lines in the graph show the changes in the data and their magnitude.
Line Chart Vs. Step Chart
Both the line and step chart may appear similar at first sight, but there are differences between both of them.
- A line Chart helps us to see the trend by connecting the data points. The primary motive of such a chart is the trend and not the Exact time of change.
- Whereas, a step chart helps highlight the exact time of change in the data, along with the trend. You can easily spot the time period where there was no change and compare the magnitude of change in each instance.
.png)
How to Create 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!
Advantages of using a Step Chart in Excel
A step chart in Excel is useful for data that changes at irregular intervals of time. For example:
- Interest rates vs. time
- Tax Rates vs. Income
- Distance covered vs. time taken
How to Create a Step Chart Without Dates
Making a step chart without dates is simple. A step chart, also called a step plot or step line chart, helps display data that changes in distinct steps, not continuously. Here’s how to create one without dates
In this situation, Excel separates the months into two sections: first, Jan to June and Second Jan to June
So, it’s clear that making a step chart with text labels instead of dates can be tricky. But don’t worry; there’s a solution. When you’re dealing with months or years, simply convert them into a date format.
For example, instead of using “Jan,” “Feb,” “Mar,” and so on, use “01-Jan-2023,” “02-Feb-2023” “03-Mar-2023,” and then extract the month information from these dates using custom formatting, like this:
Now Convert the Chart into Step Chart
How to edit a step chart in Excel after creating it?
Follow the below step to edit a step chart in Excel:
Step 1: Right-click on Various chart elements, such as data points, axis labels, or the chart area, and choose the “Format” or “Edit” option.
This will allow you to customize colors, line styles, data labels, and other aspects of the Chart.
How to create a Step Chart with date-based data in Excel?
To create a Step Chart with a date based you simply, you just need to ensure that your data is correctly formatted in the X-axis, and Excel will handle the rest of the Chart creation process.
Similar Reads
How to Create a Line Chart in Excel
Line graphs are a highly valuable tool in Excel, helping users analyze trends and patterns effectively over time. They are widely used for time-series analysis in Excel, allowing a clear visual representation of changes in data. In this guide, you'll learn how to create a line graph in Excel, includ
10 min read
How To Create a Tornado Chart In Excel?
Tornado charts are a special type of Bar Charts. They are used for comparing different types of data using horizontal side-by-side bar graphs. They are arranged in decreasing order with the longest graph placed on top. This makes it look like a 2-D tornado and hence the name. Creating a Tornado Char
2 min read
How to Create a Bar Chart in Excel?
To learn how to create a Column and Bar chart in Excel, let's use a simple example of marks secured by some students in Science and Maths that we want to show in a chart format. Note that a column chart is one that presents our data in vertical columns. A bar graph is extremely similar in terms of t
4 min read
How to Create a Thermometer Chart in Excel?
The Thermometer chart in Excel can be used to depict specific data based on the actual value and the target value. It can be used in a wide range of scenarios such as representing the past performance of horses in horse racing or the global temperature and it's variation throughout decades etc. In t
2 min read
How to Create a Tolerance Chart in Excel?
A tolerance chart shows how a particular data item compares to the maximum and minimum permissible values. In this article, we'll analyze the average results of the students of a class using a tolerance chart. Steps for creating a Tolerance Chart Follow the below steps to create a Tolerance chart in
2 min read
How to Create a Gauge Chart in Excel?
Gauge chart is also known as a speedometer or dial chart, which use a pointer to show the readings on a dial. It is just like a speedometer with a needle, where the needle tells you a number by pointing it out on the gauge chart with different ranges. It is a Single point chart that tracks a single
2 min read
How to Create a Rolling Chart in Excel?
A chart range is a data range that automatically updates as the data source is changed. This dynamic range is then utilized in a graphic as the source data. As the data changes, the dynamic range updates instantaneously, causing the chart to refresh. A common necessity when developing reports in Exc
3 min read
How to Create Pie of Pie Chart in Excel
A Pie Chart is one of the most popular data visualization tools used in Excel to display data in a circular form. However, when you have a lot of small values, they can be hard to differentiate in a standard pie chart. This is where the pie of pie chart with two data sets in Excel comes into play. I
7 min read
How to Create a Strip Chart in R?
In this article, we will be throwing light on the various methodologies to create a strip chart using various functions and its arguments in the R programming language. Method 1:Create a Strip chart of the numeric vector In this approach to create a strip chart of the numeric vector, the user needs
4 min read
How to Create a Funnel Chart In Excel
In the world of data visualization, funnel charts have become a go-to tool for illustrating stages in a process, especially when tracking sales or conversions. Learning how to create a funnel chart in Excel can give you a powerful way to visualize data that shows progression and drop-off through var
6 min read