How to Create Dynamic Chart Legends in Excel

by Charley Kyd on March 25, 2012

spacer

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...]

Tagged as: chart legends, color themes, conditional formats

spacer

{ 2 comments }

spacer tomteo March 29, 2012 at 12:09 am

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

spacer Charley Kyd September 9, 2013 at 10:54 pm

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

Thanks!

Charley

Previous post: Why INDEX-MATCH Is Far Better Than VLOOKUP or HLOOKUP in Excel

Next post: Good Examples of Bad Charts: Chart Junk from a Surprising Source

Related searches:
dynamic legend charley exceluser create
gipoco.com is neither affiliated with the authors of this page nor responsible for its contents. This is a safe-cache copy of the original web site.