Premium Only Content

How to create a Step Chart in Excel (that is fully dynamic & easy to read)
Jan 11, 2018 Excel Charts
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. For example price and inventory changes. 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.
🡻 Download the workbook here:
http://www.xelplus.com/how-to-create-step-chart-in-excel/
Other fun chart tricks:
Info Charts (non standard graphs): https://youtu.be/C9beIaL-cBA
Dynamic drop-down: https://youtu.be/22jcw5slQJk
Changing chart ranges: https://youtu.be/sHfWRb2yUrM
★ My Online Excel Courses ► https://courses.xelplus.com/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
-
1:41:00
Darkhorse Podcast
5 hours agoIf Only We’d Known: The 265th Evolutionary Lens with Bret Weinstein and Heather Heying
55.3K25 -
LIVE
Conspiracy Pilled
3 days agoThe Vaccine Conversation (S5 - Ep17)
230 watching -
Tundra Tactical
2 hours agoUSA vs Canada HOCKEY Fight: The Real PRIDE Fighting.
97 -
LIVE
LFA TV
23 hours agoWhy Exposing Waste and Fraud Terrifies the Beltway | TRUMPET DAILY 2.19.25 7PM
240 watching -
LIVE
Glenn Greenwald
1 hour agoRumble & Truth Social Sue Brazil’s Chief Censor Moraes in US Court; DC Establishment Melts Down Over Trump's Ukraine Policy | SYSTEM UPDATE #409
1,637 watching -
1:01:13
Candace Show Podcast
3 hours agoBlake Lively's BOMBSHELL Legal Filing | Candace Ep 149
64.3K86 -
1:11:22
Vigilant News Network
6 hours agoElon Musk Shuts Down RFK Jr. Critics With One Powerful Statement | The Daily Dose
37.6K11 -
Dad Dojo Podcast
18 hours agoEP20: The Super Bowl and Solving The Economy
7.44K -
4:49
Tactical Advisor
3 days agoBest Small Handgun Optics | CH PWS Shot Show 2025
5.94K1 -
1:01:21
In The Litter Box w/ Jewels & Catturd
23 hours agoI've Got Your Proof - Right Here! | In the Litter Box w/ Jewels & Catturd – Ep. 745 – 2/19/2025
84.5K24