Thanks for the reply. My task is : I have one data sheet  that will be
the source for my pivot  tables and charts. I have created  a new
worksheet that has various buttons. The macros  run when the user
clicks the button. The macro  code that i sent you is a specific view
(Based on branch and by product).If the user clicks on "Branch and by
Product", then this macro should run  the worksheet called  "Pivot"
should be populated. If the user clicks on some other button (for some
other view, say Branch and by requirement area), then the same "Pivot"
sheet should be populated by a different set of data (but from the
same source). Also, in addition to generating the pivot table  report,
I would also like to have a pivot chart. So each time, when I click
the button, i get a new chart  and the old chart show  no values. I just
want a new table report  and one new chart.

I know that the macro is not efficient because it is a recorded macro
and does some needless tasks. I will work on cutting the redundant
tasks. But if you could help me in generating only one chart, that
will be great.