How to create a regular chart (not PivotChart) based on a PivotTable

[feipezi]

Hi,
I tried to create a regular chart right beneath a PivotTable but always ended up with a PivotChart, which is not what I wanted.
In the PT, I have some products (row field) quantity showing over a time period (column field). I want to see the trend of those products performance. But the PivotChart will always give me something the other way around: the time becomes Series(es) and the products on the X-axis.
Thanks in advance.

 

[SkipVought]

Hi,

This is really a Forum68 question, as it has nothing to do with VBA.

What I do is use MS Query to simulate the data in a PivotTable or run an Advances Filter to get UNIQUE values and then use SUMMARY FUNCTIONS, like SUMIF, COUNTIF, SUMPRODUCT etc to populate the aggregations.


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}