Yeah. There are a lot of data columns. Let us say:
Data column (A)='Branch'
Data column (B)='Product'
Data column (C)='Requirement Area'
Data column (D)='Process Area'
Data column (E)='Level'
So on till Data column (M).

So that makes we can view the data depending on what we wanted to see.
For e.g, the macro  that I wrote is for "branch vs product view".
Similarly there will be multiple views that an user can choose. The
choices will be in a main sheet. when a user clicks on one button,
that particular view macro will run  and the result will be dissplayed.
The pivot table  will be created  and dispalyed on one sheet  called
"Pivot". That works fine. But similarly i want just one chart  only.
When the user clicks a dfiferetnt view, then along with the change in
pivot table, the same chart should also change. I dont want a
different chart to be created each time.