Category:

Course Description:

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. Course Length: 29:25 minutes Source: Leila Gharani

Thousands of courses

DisclaimerMany of the curated courses have been manually added into our Learning Management System, then enhanced with structure, descriptive, activities and consolidation,  referencing who the content creators are (where required). If you like the curated content from any creator and like their materials, please feel free to connect with them directly to explore their full libraries of paid programs. 

We will continue to add more curated quality content as well as increasing partnerships with creators to provide you with an all-in-one skills development platform. 

Book a demo now!

Tell us a bit about you. After review, you will receive an invite calendar where you can select your demo time.