How to do Pivottable but regular chart?

[feipezi]

Hi,
I have a Pivottable on a Worksheet but I don't want to create a PivotChart: I want a regular chart, which will be dynamic because it will change with the change of the PT.
I was trying to create a regular chart based on the PT's RowRange and ColumnRange data but it would always give me a PivotChart, which was not what I wanted.
Now the only way of doing it, for me, is to copy the PT data to another temporary sheet and create the chart based on the data on that sheet. It worked but I still want a regular chart based on the existing PT.
I saw someone did it but I can't.
Thanks in advance.

 

[SkipVought]

hi,

how complex is your PT?

how large is your PT source?

I would create my own separate summary table as the source data for the chart.

Skip,

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