Creating chart out of pivot table using vba

[Loubia]

Hello,

I am trying to generate a 4 lines chart out of a pivot table.

Basically my pivot table looks like this:
Piv forum.PNG

And the chart I get looks like this
Chart forum .PNG

I would like a chart with and X axis of months and a Y axis of revenues and 4 lines that each represents an employee.

The code I'm using is as follows:

Please Login or Register  to view this content.

I appreciate your help.

[CK76]

You'll need to switch PivotTable fields.

Month field should go in xlRowField to have x-axis plotted by Month.

If you want to keep current PivotTable structure. I'd copy the pivot table to hidden sheet and base chart off of that Pivot table.

[Loubia]

Thank you