Data Labels disappearing from charts
This is a real problem !! When you refresh a picot chart the Data Labels either totally go away or some of them do... It's inconsistent .
This same problem was inherited by the Web version btw.
Thanks for the feedback. This is an issue that we are investigating.
Andreas, edacentrum commented
This issue is a real problem for us and our external partners! For compliance reasons, work arounds with Add-ins or VBA is not a solution at all. When will this issue, that is known since 2015, completely be solved?
I can provide an example file to reproduce the error in excel office 365 desktop version and excel 2013!
I have the same problem. I use cells to provide data for all data labels on the chart. When I save the file, close it and reopen, my labels are gone. I mean they there but contain nothing, as if something emptied them. The only thing that helps is to delete them and recreate.
My workaround is to use macro which refills all data labels with text every time an action happens in the cells used by the chart. Looks kinda like this (only part of it):
Dim ChangeSeries As Series
Dim m_cht As Chart
Set m_cht = Worksheets("Tracker").ChartObjects("Chart 9").Chart
Set ChangeSeries = m_cht.SeriesCollection(2)
.HasDataLabel = True
.DataLabel.Text = Sheet1.Range("Q12").Value
.HasDataLabel = True
.DataLabel.Text = Sheet1.Range("Q13").Value
When I update the chart with data labels and change the filter the data labels disappear. I tried to do this in different ways but of no use. Can anyone help me with this problem?
One used to be able to copy charts and past as a picture in another document. Now the Series Labels are changed from the correct labels to Series 1, Series 2, etc. What gives?
I am having this problem with a dynamic named range. Series data labels disappear after criteria has changed.
We have not been able to repro your issue. Would you be able to provide us more details on the version of Excel you are using and a sample file? We can follow-up via email on this.
I am constantly having this issue as well for what its worth (with the desktop version, I don't use the web version).