Join 400,000+ professionals in our courses here https://link.xelplus.com/yt-d-all-courses

In this video you'll learn how to setup a step chart in Microsoft Excel. A stepped line graph, often referred to as a step chart, resembles a traditional line graph but features a distinctive series of steps connecting the data points. This type of chart is particularly effective for displaying changes occurring at irregular intervals, providing a clear visualization of each specific shift in the data.

⬇️ Download the workbook here: https://pages.xelplus.com/step-chart-file

What's Inside:
Step-by-step guide on creating step charts in Excel for visualizing irregular data changes.

▪️ Understanding Step Charts: Ideal for visualizing price changes and inventory fluctuations.
▪️ Data Preparation: Setting up a dynamic data table for step chart visualization.
▪️ Building the Chart: Detailed instructions on creating, formatting, and adding dynamic labels to the step chart.
▪️ Making It Dynamic: Techniques to ensure the chart updates automatically with new data.
▪️ Improving Readability: Customizing data labels for clarity and visual appeal.

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.

My Online Excel Courses ► https://www.xelplus.com/courses/

Contributions
Thanks to Bart Titulaer (Lecturer at Fontys International Business School in Venlo, Netherlands) for providing the Step Chart Template.

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

️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join

Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

RESOURCES I recommend: https://www.xelplus.com/resources/

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/xelplus

0:00 Setting up Stepped Line Chart in Excel
3:36 Data Preparation for Step Chart
12:34 Improve Readability
21:53 Creating A Dynamic Step Chart

#excel