How to create dynamic labels and colours in Microsoft Excel
Tired of your chart labels overlapping with negative values? In this video, I’ll show you how to create dynamic labels that automatically adjust based on the direction of the bar — no more cluttered charts!
Plus, I’ll show you how to apply dynamic colours, so negative values automatically change colour, making your charts easier to read and visually engaging.
We’ll use Premier League goal difference data as our example, and you’ll come away with a clean, professional-looking bar chart that responds to your data.
Perfect for Excel users and data designers looking to level up their chart game!