How to Create Dynamic Chart Legends in Excel

by Charley Kyd on March 25, 2012

These two charts show different versions of the same random data. Notice that as the order of the chart series changes, the legend adapts automatically.

When I saw a chart with a legend like this in the Wall Street Journal, I knew I had to add a similar chart to my Swipe Files…but in Excel, we need dynamic legends!

Using dynamic legends is such a great idea, I also need to blog about it.

What’s A Dynamic Chart Legend?

Dynamic chart legends change as your data changes.

For example, this legend automatically adjusts so that the information about the top line also is at the top of the legend bar, and the information about the bottom line is at the bottom of the bar, and so on.

[click to continue…]


tomteo March 29, 2012 at 12:09 am

Hi Charley, I think the formula should be =$P3=1 and so on instead 🙂

Charley Kyd September 9, 2013 at 10:54 pm

You’re right! The current version now shows the corrected information.



Previous post:

Next post: