question

KyleRosenberg-5877 avatar image
1 Vote"
KyleRosenberg-5877 asked KyleRosenberg-5877 commented

Why are the images not working for certain markers in this chart?

I have two documents - one where the image set in the chart.xml for the marker is showing in the chart (markers_show.docx), and one where its just showing the "automatic" marker (markers_dont_show.docx). In both charts, the c:marker node for the "Aggressive Model No 2" series is under a c:dPt node and are identical. Also in both charts, the Marker Options shows the "Automatic" option checked rather than "Built-in" with the image type. Why is markers_show.docx rendering the marker with the image and markers_dont_show.docx not? Is there somewhere else in the ooxml that this is set?


openspecs-office-fileformats
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @KyleRosenberg-5877,

I'm looking at the two documents and will get back to you shortly.

Best regards,
Tom Jebo
Sr Escalation Engineer
Microsoft Open Specifications

1 Vote 1 ·

Hi @KyleRosenberg-5877
I have alerted the open specifications team regarding your inquiry. A member of the team will be in touch soon.

Regards,
Obaid Farooqi - MSFT

0 Votes 0 ·

Hi @KyleRosenberg-5877,

Initial investigation shows that the row 8 that was added to the backing data sheet (Windward_ChartData_1.xlsx) is what triggered the marker issue. I haven't actually made all the logical connections to why this happened yet but if I remove that extra row (which is empty BTW, so not sure if it was accidental or not) then the markers show again.

I can try to track down the reason that caused the marker images to default. Or if you think that's enough to help you, let me know.

Tom

0 Votes 0 ·

1 Answer

TomJebo-9587 avatar image
0 Votes"
TomJebo-9587 answered KyleRosenberg-5877 commented

Hi @KyleRosenberg-5877,

Digging into this further, I found that when row 8 that is inserted to the backing data sheet (Windward_ChartData_1.xlsx), creating that extra blank row with "5.5" in the row header (i.e. first column), I see the following which seems to be closer to the problem:

     <c:ser>
       <c:idx val="12"/>
       <c:order val="12"/>
       <c:tx>
         <c:strRef>
           <c:f>Windward_ChartData_1!$N$1</c:f>
           <c:strCache>
             <c:ptCount val="1"/>
             <c:pt idx="0">
               **<c:v>Moderately Aggressive Model No 2</c:v>**
             </c:pt>
           </c:strCache>
         </c:strRef>
       </c:tx>
       <c:spPr>
         <a:ln w="25400">
           <a:noFill/>
         </a:ln>
       </c:spPr>
       <c:dPt>
         **<c:idx val="16"/>**
         <c:marker>

Notice in particular the bolded <c:idx val="16"/>.

Now look at the y value reference:

       <c:yVal>
         <c:numRef>
           <c:f>Windward_ChartData_1!$N$2:$N$23</c:f>
           <c:numCache>
             <c:formatCode>General</c:formatCode>
             <c:ptCount val="22"/>
             **<c:pt idx="17">**
               <c:v>14.69</c:v>
             </c:pt>
           </c:numCache>
         </c:numRef>
       </c:yVal>

Notice again the bolded <c:pt idx="17">.

I believe these should be the same index values.
The first is the <c:dPt><c:idx> or single data point index and is where the marker is defined.
The second is <c:yVal><c:numCache> value cache for the corresponding data index and contains the last displayed value or "14.92".
However, they don't match. The correct index should be 17 and this allows the point to plot on the chart. But the index used in the <c:dPt><c:idx> element where the marker is defined is not correct. Therefore the marker doesn't show. When I correct the <c:dPt><c:idx> value to be "17", the marker shows.

So I think what's happening, still not sure exactly how, is that when the extra row was added, numCache points are adjusted to account for the extra row of data. But the <c:dPt><c:idx> is not adjusted.

I hope this makes sense to you. Let me know if you have further questions.

Tom


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

That does make sense, thank you for your help

0 Votes 0 ·