Hi all

I have got a Pivot table created through OLE automation from a range of data and I now need to create a chart based on the pivot data range. I would appreciate if you advise how can I determine the pivot data range programatically as the data range is one of the necessary parameters to the ChartWizard method.

Thanks & Best Regards