Exporting to Excel - Pivot Table and Charts
I have a requirement on exporting a report to excel.
On one sheet I must have a pivot table (the kind of pivot table that xxl creates), but on the other one bar charts according to the information (like what ole library does).
Is it feasible to achieve the requirement using only one book,I am asking these cause I have not found any information or example that ole can achieve this kind of pivot table ??? If it is, how?