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

In this video I show you how to dynamically ignore blank dates and errors in charts. This trick doesn't just apply to dates, but to any data set that has gaps in it and you'd like Excel to completely ignore the gaps, even for cases where you have values in front of the gaps.

⬇️ Download the workbook here: https://pages.xelplus.com/remove-gaps-in-charts-file

Key Learning Points:
- Dynamic Formula Approach: Learn a dynamic method for ignoring blank cells and error values in both X and Y axes of Excel charts.
- Data Preparation Table: Understand how to create a dense data preparation table that filters out blanks and errors, providing clean data for charting.
- Innovative Use of Index Formula: Explore how the Index formula can efficiently return dates and numbers, filtering out unwanted cells.
- Advanced Excel Techniques: Delve into the use of advanced functions like Aggregate and Rows, and how they contribute to accurate data filtering.
- Creating Dynamic Charts: Step-by-step guide on creating dynamic charts that automatically update with your data.
- Utilizing Name Manager: Learn the crucial role of Name Manager in creating dynamic charts and how to set it up effectively.
- Practical Application and Testing: See the formulas in action with practical examples, ensuring your chart responds dynamically to changes in data.

This video shows you how to use the Aggregate functions, Index & Match and Name Manager to get the desired result automatically.

Links to related videos:
Part 1: Manual approach to removing gaps in charts: https://youtu.be/lQG-g6_noPc
Index & Match basics: https://youtu.be/F264FpBDX28
Index & Match advanced: https://youtu.be/ontXHp9cwOQ
Changing Chart Ranges with Index: https://youtu.be/sHfWRb2yUrM

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

️ 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

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!

#excel