Post this question in the "microsoft.public.excel.charting" newsgroup. Debra
D. hangs out there and she's a wiz with pivot table :-)

--
Toby Erkson
Oregon, USA
Excel 2002 in Windows XP

"rbekka33 " wrote in message
...
Hi

i need to create a vba macro which creates a pivot table and also hides
all blanks. Any ideas? I am still trying to filter out records which go
back to 1996, only keeping the 2004 records.

thanks


---
Message posted from http://www.ExcelForum.com/