pivotchart from access database

hello everybody,
I am a newbie in VB and want to plot pivotchart from an MS Access datbase using VB. Any suggestion is most welcome. I have done searches in the VB Forum about pivotchart but did not get any result.

I am under pressure to do it as quickly as possible. So please help me.

Regards,
Amir

Pivotcharts are primarily associated with Excel.

So, is your question how to create an Excel Pivotchart using data in an MS Access database?

Hi Hack,
Not actually excel pivotchart. There is option in the design view for a pivot chart in Access 2003. I can draw pivotcharts manually, but have to do it programmatically using VB6.

Any help is appreciated.
Thanks,
Amir