Hi all; Please take a look at the file ATE-4760.docx . Why do data labels not appear for the red & green lines? If you look inside the chart1.xml, in the <c:dLbls> part it has: <c:showVal val="1"/> So why does it not show? And for my use, I don't need to know how to make it show, I need to know why in this case it does not show as I need to duplicate that behavior. thanks - dave

Dave, So in your chart1.xml, you actually only have two labels defined, "Approved" and "Available". When I ask Microsoft Word's UI to "show the labels for the data points", it actually has to add all the individual data point labels like this: <c:dLbl> <c:idx val="1"/> <c:delete val="1"/> <c:extLst> <c:ext xmlns:c15="http://schemas.microsoft.com/office/drawing/2012/chart" uri="{CE6537A1-D6FC-4f65-9D91-7224C49458BB}"/> <c:ext xmlns:c16="http://schemas.microsoft.com/office/drawing/2014/chart" uri="{C3380CC4-5D6E-409C-BE32-E72D297353CC}"> <c16:uniqueId val="{00000004-09EB-4C88-9E2A-9B38D3E6DFC7}"/> </c:ext> </c:extLst> </c:dLbl> <c:dLbl> <c:idx val="2"/> <c:delete val="1"/> <c:extLst> <c:ext xmlns:c15="http://schemas.microsoft.com/office/drawing/2012/chart" uri="{CE6537A1-D6FC-4f65-9D91-7224C49458BB}"/> <c:ext xmlns:c16="http://schemas.microsoft.com/office/drawing/2014/chart" uri="{C3380CC4-5D6E-409C-BE32-E72D297353CC}"> <c16:uniqueId val="{00000005-09EB-4C88-9E2A-9B38D3E6DFC7}"/> </c:ext> </c:extLst> </c:dLbl> <c:dLbl> <c:idx val="3"/> <c:delete val="1"/> <c:extLst> <c:ext xmlns:c15="http://schemas.microsoft.com/office/drawing/2012/chart" uri="{CE6537A1-D6FC-4f65-9D91-7224C49458BB}"/> <c:ext xmlns:c16="http://schemas.microsoft.com/office/drawing/2014/chart" uri="{C3380CC4-5D6E-409C-BE32-E72D297353CC}"> <c16:uniqueId val="{00000006-09EB-4C88-9E2A-9B38D3E6DFC7}"/> </c:ext> </c:extLst> </c:dLbl> .... So above you see two of the 9 or 10 data point labels that Word adds. And you check by opening this in Word, selecting the series plot, formatting the data labels in the side bar and first unchecking then checking the "Value" checkbox. That causes Word to have to write out the XML to show all the labels. Like this: Tom P.S. I only posted this as an "Answer" post because I couldn't fit it in a comment. Feel free to respond if this doesn't answer your question.

Why do the data labels not show in this chart?

Accepted answer

Tom Jebo 1,996 Reputation points Microsoft Employee

2021-02-24T00:17:43.207+00:00
Dave,

So in your chart1.xml, you actually only have two labels defined, "Approved" and "Available". When I ask Microsoft Word's UI to "show the labels for the data points", it actually has to add all the individual data point labels like this:

<c:dLbl> <c:idx val="1"/> <c:delete val="1"/> <c:extLst> <c:ext xmlns:c15="http://schemas.microsoft.com/office/drawing/2012/chart" uri="{CE6537A1-D6FC-4f65-9D91-7224C49458BB}"/> <c:ext xmlns:c16="http://schemas.microsoft.com/office/drawing/2014/chart" uri="{C3380CC4-5D6E-409C-BE32-E72D297353CC}"> <c16:uniqueId val="{00000004-09EB-4C88-9E2A-9B38D3E6DFC7}"/> </c:ext> </c:extLst> </c:dLbl> <c:dLbl> <c:idx val="2"/> <c:delete val="1"/> <c:extLst> <c:ext xmlns:c15="http://schemas.microsoft.com/office/drawing/2012/chart" uri="{CE6537A1-D6FC-4f65-9D91-7224C49458BB}"/> <c:ext xmlns:c16="http://schemas.microsoft.com/office/drawing/2014/chart" uri="{C3380CC4-5D6E-409C-BE32-E72D297353CC}"> <c16:uniqueId val="{00000005-09EB-4C88-9E2A-9B38D3E6DFC7}"/> </c:ext> </c:extLst> </c:dLbl> <c:dLbl> <c:idx val="3"/> <c:delete val="1"/> <c:extLst> <c:ext xmlns:c15="http://schemas.microsoft.com/office/drawing/2012/chart" uri="{CE6537A1-D6FC-4f65-9D91-7224C49458BB}"/> <c:ext xmlns:c16="http://schemas.microsoft.com/office/drawing/2014/chart" uri="{C3380CC4-5D6E-409C-BE32-E72D297353CC}"> <c16:uniqueId val="{00000006-09EB-4C88-9E2A-9B38D3E6DFC7}"/> </c:ext> </c:extLst> </c:dLbl>

....

So above you see two of the 9 or 10 data point labels that Word adds. And you check by opening this in Word, selecting the series plot, formatting the data labels in the side bar and first unchecking then checking the "Value" checkbox. That causes Word to have to write out the XML to show all the labels. Like this:

Tom

P.S. I only posted this as an "Answer" post because I couldn't fit it in a comment. Feel free to respond if this doesn't answer your question.
Please sign in to rate this answer.
David Thielen 61 Reputation points

2021-02-24T00:26:06.06+00:00

Hi Tom;

Please look at ChartWithDataLabels.docx. It does not set a dLbl for each point. Instead it just has it per chart. Why is it needed per point in the above case?

thanks - dave

Tom Jebo 1,996 Reputation points Microsoft Employee

2021-02-24T01:20:11.397+00:00

Ok, so I'll backtrack a little, I was looking at the wrong series. In the series in question, you do have the "Approved" and "Available" <dLbl> blocks defined but also have the data point block defined. However, in the data point <c:dLbl> blocks, you also have the <c:delete> element defined. That is affecting Word's decision to "show" the values especially when you don't have <c:showVal> set to "1" in each of the data points that also have <c:delete>.

<c:delete> and <c:showVal> (="1") are mutually exclusive.

David Thielen 61 Reputation points

2021-02-24T15:56:21.393+00:00

Hi Tom;

Now that I see the <c:delete val='1'/> I feel like an idiot. That turns it off regardless of anything else - correct?

I assume this was put in to provide the ability to turn off just some labels, but it can also be used to turn them all off.

thanks - dave

Tom Jebo 1,996 Reputation points Microsoft Employee

2021-02-24T18:02:08.007+00:00

It actually is documented this way:

21.2.2.40 delete (Delete)
This element specifies that the chart element specified by its containing element shall be deleted from the chart.
This should be set to true if the application adds these elements by default even after the user has specified that
they should be removed from the chart

So it makes sense that Word would not display these labels and even anything else added to the label wouldn't affect it's rendering.
But yeah, it wasn't obvious at first investigation so don't feel like an idiot. I initially didn't see it either. :)
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Why do the data labels not show in this chart?

0 additional answers

Your answer