Create graph using Pivot table

[adr12345]

Hi,

I have a pivot table and I need a code which will create graph using that Pivot table.

Graph should be in same worksheet ans should get linked to the Pivot table.

Any idea how it can be done?

Pivot table looks smthn like that.

Category	Jan	Feb	Total
A	15	2	17
B	20	23	43
C	41	1	42
Total	76	26	102

<tbody>
</tbody>

 

[Steve=True]

Hi Adr12345,

Pivot charts and graphs are already included functionality. All you need to do is be within the Pivot table and insert a chart. Excel will take care of the rest.

Here is a tutorial and video demonstrating the process:
how-to-create-a-dynamic-excel-pivot-table-dashboard-chart

Here is how you can add slicers to the pivot table and pivot chart:
how-to-insert-slicers-into-an-excel-pivot-table
Hope this helps.

Steve=True

 

[adr12345]

Hi Steve,

Thanks for replying to my query. However I am looking for a VBA code which will take care of everything.

Thanks,
adr12345