Thursday 20 November 2014

Clone Data Labels and Conditionally Show Data Labels

Excel 2013 has a feature which allows you to clone data labels. It's pretty handy but I decided to make my own version.

Here's a 100% Stacked Bar Chart with default data labels.



They're not easy to see, and the number format could be better shown as a percentage. So I have formatted a single data label like this.



Now I select AET Chart Tools on the AddIns tab, then Clone Selected Data Label.



My version works with the active series, active chart, all charts on the active sheet, and also the active workbook. Cloned format includes fill colour, font colour, font name, font size, bold/italic font and number formatting. It also works with Excel versions 2007, 2010 and 2013.

Active Chart will do in this case.



Here's the cloned data labels. Please forgive my yucky colour choices.



Moving right along, I'm only interested in values bigger or equal to 50%. So this time I select Conditionally Show Data Labels.



Same selection choices are available. This tools works with Excel versions 2003, 2007, 2010 and 2013. Possibly earlier versions too but I don't have them to test with.



And we're done.



Download my updated AET Chart Tools here.

See you next time.