Lesson Description

This lesson will guide you through creating a dynamic and visually impressive conditional clustered column chart with a moving target line using Microsoft Excel. If you've ever wondered how to make your charts both informative and aesthetically pleasing, this one’s for you.

Learn how to add extra columns strategically and use conditional formulas to highlight specific data points. By the end of this lesson, you'll have a visually appealing and insightful chart — demonstrating the power of conditional formatting and dynamic data visualisation in Excel.