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

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.
2,431 questions
0 comments