Скачать с ютуб How to Make a Step Chart in Excel (fully dynamic & easy to read) в хорошем качестве

How to Make a Step Chart in Excel (fully dynamic & easy to read)

Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-cou... 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-... 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):    • This Excel Chart will grab your atten...   Dynamic drop-down:    • Excel Dynamic Chart with Drop down Li...   Changing chart ranges:    • How to Create a Dynamic Chart Range i...   ➡️ Join this channel to get access to perks:    / @leilagharani   👕☕ 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:   / lgharani   LinkedIn:   / 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