How to create Charts in spreadsheet referring the Pivot table data using OpenXML SDK in C#?

Question

We need to create bar chart and pie chart in spreadsheet with pivot table data using OpenXML SDK in C#. Currently I am using OpenXML to create excel sheets which requires further to create Bar Chart and pie chart.

First, we need to create pivot table with the database data table record and then with the created pivot table data, further I need to create pie chart and bar chart. I don't find any reference solution over internet using Openxml, so it will be great if any sample code is provided to understand and proceed further.

Answer 1

Hi @Geetanjali Sahni

The tag Office Open Specifications is dedicated to supporting issues related to open specifications. You can find open specifications here https://learn.microsoft.com/en-us/openspecs/

You inquiry is not related to open specifications. You may want to post your inquiry to stack overflow at the following link

https://stackoverflow.com/questions/tagged/openxml-sdk

Also there are samples at the following locations that you may find useful

https://learn.microsoft.com/en-us/office/open-xml/how-do-i

https://github.com/dotnet/Open-XML-SDK/tree/main/samples

I have removed the Office Open Specifications tag from your post.

Regards,

Obaid Farooqi - MSFT