• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamic Chart Data Label [SOLVED]

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
 
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
 
Back
Top