SharePoint how to export chart to Excel

Question

SharePoint how to export chart to Excel

Sevil Red 101

Good day,

I have the script to show ViewsLastMonths2 and ViewsLastMonths2Unique on SP 2016 page. I show ViewsLastMonths2 on diagram by Chart.js https://www.chartjs.org/

I export ViewsLastMonths2 data to Excel. But I can't export the Chart to excel.

How can I show in Excel file ? This information didn't help https://learn.microsoft.com/en-us/office/dev/add-ins/excel/excel-add-ins-charts

My script63092-codeexample1.txt

Accepted answer

0 additional answers

Your answer

Answer 1

MichaelHan-MSFT 18,126

Hi @Sevil Red ,

To export the Chart to Excel, you could try this way；

var rang = oSheet.Range("A1:C10");  
var ch = oSheet.ChartObjects().Add(rang.Left +   
rang.Width, rang.Top, 350, 220);  
ch.Chart.ChartType = 4;  
ch.Chart.SetSourceData(rang, 2);

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Sevil Red 101 Reputation points

2021-02-03T12:42:45.983+00:00

Thanks for reply,

What is number for chart type "bar" or "doughnut"?

ch.Chart.ChartType = ???
MichaelHan-MSFT 18,126 Reputation points

2021-02-04T01:10:25.247+00:00

Hi @Sevil Red ,

For the value of the charttype, you could refer to XlChartType enumeration: https://learn.microsoft.com/en-us/office/vba/api/excel.xlcharttype

57 is for Clustered Bar. -4120 is for Doughnut.

If my reply helps you, please accept it as answer via the "Accept Answer" button.

Sevil Red 101

Thank you very much!
I set "doughnut" type. How to set labels range A1 for this doughut? Now the chart labels have value "1","2","3"

            oSheet.Range("A1:D1").Font.Bold = true;     
             var rang = oSheet.Range("C2:C11");
             var ch = oSheet.ChartObjects().Add(rang.Left + rang.Width + 100, rang.Bottom + 100, 650, 420);
             ch.Chart.ChartType = -4120;
             ch.Chart.SetSourceData(rang, 2);
            oExcel.Visible = true;
            oExcel.UserControl = true;

Share via

SharePoint how to export chart to Excel

0 additional answers

Your answer