Easiest Step Chart in Excel (this trick will surprise you!)

1 year ago
8

May 3, 2018 Excel Charts
Use this trick to create a super quick dynamic Step chart in Excel (great graph to show price & inventory fluctuations).

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. There are different ways to get the right visualization. This videos shows you the easiest version. It uses a little chart trick called error bars.

★★ Contributions ★★

Many thanks to Mehdi & to Bart for providing us with different methods of creating the Step Chart.

🡻 Download the workbook here 🡻
http://www.xelplus.com/how-to-create-step-chart-in-excel/

★ Links to related videos: ★
Alternative version of Step Chart: https://youtu.be/ksR63M9nuYM

★ My Online Excel Courses ★

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 #LeilaGharani

Loading comments...