HI,

Have a read on Jon's article.
http://pubs.logicalexpressions.com/P...cle.asp?ID=553

Also Debra has a pretty extensive set of pages on Pivot related topics.
http://www.contextures.com/xlfaqPivot.html

Cheers
Andy


Amit Patel wrote:
Hi, Pivot Charts has restrictions of making XY Scatter charts using Pivot
Tables. But i need to make XY Scatter Chart through Pivot Table. Is there any
way to do it so or i have to manually generate pivot table data , copy it on
to sheet and use that static data to generate report ?

Plz let me know ASAP

Regards

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info