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

Parinitha Nagaraja 1 Reputation point

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


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


3_ExcelDataForScatterChart.png - Excel data with data points


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


Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,657 questions
0 comments No comments
{count} votes