Dynamic Chart Data Label [SOLVED]

[Jeffrey Lebowski]

Hello,


I have a simple bar chart listing employee data. I have cleaned it of the normal chart clutter (axes, gridlines, category name & legend) and want to add some dynamic data labels. I have added a combo box control to the chart as well as a dummy series so that you can select any employee name, and their data bar is highlighted red.


Since I do not have the y-axis displayed, I want to include a data label for only the highlighted bar. This will need to change as the combo box selection changes.


Searching chandoo.org I was not able to find this solution.


Thanks for your help! Please see the sample workbook attached.

https://www.dropbox.com/s/9rzcgan9exlxskk/data%20labels.xlsx

 

[Jeffrey Lebowski]

I just figured this out...with the help of the articles here on Chandoo .


Selecting the range for data labels would give 0's where I wanted blanks...but if I go to each individual point and set that data label text box equal to specific label cell, the blanks no longer show as zeroes!


Check it out:

https://www.dropbox.com/s/9rzcgan9exlxskk/data%20labels.xlsx