Open XML Format SDK 2.5 - Scatter plot does not load properly when embedded in Word document

Parinitha Nagaraja 1 Reputation point
2022-11-02T19:12:52.267+00:00

I am using Open XML Format SDK 2.5 for generating word document with scatter charts embedded.
Scatter chart does not load correctly when I open the word document.

The excel data which has the data points looks correct but for some reason, the word document does not show the data points correctly in the chart.

Only after I click "Edit data" on the chart , and view the excel data once, it starts to load correctly.

Please let me know the solution. Thank you in advance.

Attaching screenshots :

1_IncorrectScatterPlot_DataPoints.png - When word document is opened for the first time, it does not load the chart properly

256541-1-incorrectscatterplot-datapoints.png

2_ClickOnEditData.png - Right click on chart -> Click on Edit data

256434-2-clickoneditdata.png

3_ExcelDataForScatterChart.png - Excel data with data points

256551-3-exceldataforscatterchart.png

4_CorrectScatterChart_AfterEditData.png - Chart gets loaded correctly in the word document

256497-4-correctscatterchart-aftereditdata.png

Microsoft 365 and Office | Development | Other
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.