Creating chart using Pivot Table - Multiple select on filter is not working in .NET

Aspose.Cells Product Family
1

Hi,


While creating charts using pivot table,
We are not able to select multiple options on report filters.

Can you please provide a solution for it ASAP.

Thanks in advance.
2

Hi,

Could you explain your issue more. As we told you earlier, we only support to add a pivot chart and do not support setting the data series, points etc. by API. Which multiple options on report filters you are talking about, are these of pivot table or pivot chart? We would appreciate if you could paste your sample code and template file to show the issue, we will check it accordingly.

Thank you.

3

Hi,


Using the following code we are creating the filter options for the chart.

pivotTable.AddFieldToArea(PivotFieldType.Page, dt.Columns[“Principal”].Ordinal);
pivotTable.AddFieldToArea(PivotFieldType.Page, dt.Columns[“Region Name”].Ordinal);
pivotTable.AddFieldToArea(PivotFieldType.Page, dt.Columns[“Country Name”].Ordinal);
pivotTable.AddFieldToArea(PivotFieldType.Page, dt.Columns[“NominatiOn Type”].Ordinal);
pivotTable.AddFieldToArea(PivotFieldType.Page, dt.Columns[“ATS Year”].Ordinal);
pivotTable.AddFieldToArea(PivotFieldType.Page, dt.Columns[“ATS Quarter”].Ordinal);
pivotTable.AddFieldToArea(PivotFieldType.Page, dt.Columns[“ATS Month”].Ordinal);

Please find the attachment for the multiple selection issue.
I was able to select multiple options in the drop down but it is not reflected in the Chart.

Thanks in advance.
4

Hi,

Well, I think you are talking about pivot field buttons. They are shown in the Excel 2003 for XLS but not shown in MS Excel 2007 for XLS and XLSX files. May be it is the default behavior of MS Excel 2007 that does not show the pivot fields buttons on the pivot charts.

Could you create a pivot chart manually in MS Excel and post the file here to show if the buttons are displayed on pivot chart. We will check it soon.

Thank you.

5

Hi,


Please find the attached excel. following steps has been done on it,

1. Created pivot table
2. created pivot chart by providing pivot table as input.
3. Selecting multiple options in the filter is possible. check the “principal” & “vessel name” filters on the top.

Thanks
6

Hi,

Thanks for providing us the sample file that was probably created manually in MS Excel. I have checked, the multiple filters are working fine and are reflecting in the pivot chart accordingly. We appreciate if you could post your generated file by Aspose.Cells API, in which multiple selects(filters) are not working and are not reflecting in the pivot chart when clicking/selecting on the filters in pivot report table. We will check your issue soon.

Thank you.