In Excel Charts, we show how to create a step chart in Excel. We now show an easier way to do this.
Data Analysis Tool
Real Statistics Data Analysis Tool: The Real Statistics Resource Pack contains the Step Chart data analysis tool which creates up to six step charts.
Example 1: Use the Real Statistics Step Chart data analysis tool to create the step chart for the data in range B3:E9, press Ctrl-m, choose the Step Chart option from the Desc tab (or double click on the Step Chart option if using the original user interface), fill in the dialog box that appears as shown on the lower left side of Figure 1 and click on the OK button.
The output is shown on the right side of Figure 1.
Figure 1 – Step Chart
Reference
Extend Office (2021) How to create a step chart in Excel
https://www.extendoffice.com/documents/excel/4987-excel-step-chart.html