This tutorial is a Step by Step approach to creating a Step Chart in Excel from Scratch. You can also download the template from the link below.
What is a Step Chart?
A Step Chart is great for visualizing variables that change on an irregular basis. It can be used to visualize inventory or price fluctuations. Basically for variables that have an irregular demand. For example:
- When you have irregular time intervals between incoming or outgoing goods
- Quantity changes such as spare parts in maintenance
- Price fluctuations for raw materials
If you create a line chart directly on the data set you will realize it doesn’t show the correct visualization.
For the correct visualization you need a data preparation table that plots two points for each value. One point represents the value before the change and the second point the value after the change.
Once you get past this step, you can further improve the readability of the Excel Step Chart by taking additional steps to bring the data labels inside the chart instead of relying on the axis. This improves the readability of the chart.
The last part of the video shows you how to create a fully dynamic Step Chart so that when new dates are added, the chart updates automatically. We do this with Excel’s OFFSET function and Name Manager to create dynamic chart ranges.
★★ Contributions ★★
Thanks to Bart Titulaer (Lecturer at Fontys International Business School in Venlo, Netherlands) for providing the Step Chart Template.
Watch the steps in this video:
Feel free to Download the Workbook HERE.
The new Excel Dashboards course is here!
Now available on Udemy
Visually Effective Excel Dashboards for your reports.
Redeem your coupon for 75% off below.