I created an Excel file with 3 tabs, ie: Chart, Data en Pivottable
On the 1st tab (Chart) I created a chart combining two dataseries (from the Pivottable) and two Y-axis.
In Excel all is looking ok (see attachment) but when I create the graph through exporting my data to the file on tab Data and refresh Pivottable and Chart, my Chart is totally different:
- no second dataset shown as a line
- no second y-axis
- labels on the x-axis is incorrect
By code I do this:
worksheet.Cells.ImportDataTable(dataTable, true, 0, 0, false);
Can anyone please explain to me why the chart ain't simply a copy of the one I created in Excel?