Creating Pivot Table using Database

[chandrashekar]

Hi,

How to create pivot table using access database. Pls help me out.

Thanks in advance.

 

[chandrashekar]

Hi,

No I did'nt tried because output will differ. For Ex: If I create pivot table using external data base connection through macro recorder it will work nicely, but if i write VBA code for it I am getting different result such as sum of total and sum of percentage.

Is there any way to add chart to worksheets using VBA code.

Regards,

Chandrashekar

 

[Andrew Poulsom]

Sorry, I don't understand. There is an option to include a chart at Step 1 of the Pivot Table Wizard.

 

[chandrashekar]

Hi GM,

Atlast I got the desired result. Thank you for your support.

Regards,

Chandra Shekar