Hi,
1) Well, you may create pivot tables and pivot charts in Excel formats (xls/xlsx etc.) but I am afraid, you cannot render pivot tables and charts in PDF conversion. The reason is we do not support to calculate the pivot table data or read pivot tables yet, we are already working on this feature. Hopefully, this will be support soon.
Anyways, I have logged your request into our issue tracking system with an id: CELLSNET-19340. We will notify you when it is done.
2) Well, Aspose.Report does have Chart component and you can make charts based on your data, but the charts are not conventional or native Excel charts. For further info, please post a query in Aspose.Report forum and Aspose.Report team would help you soon.
Thank you.