Hi,
I am learning excel 2007 while working on the job. I have a simple query.
My base data from which I want to create pivot tables and pivot charts is stored in file called: Base_Data.xlsx
I want to create two separate files for pivot tables and pivot charts (based on the pivot tables) linked to the same data base as follows:
Pivot_Table.xlsx (based on the Base_Data.xlsx file)
Pivot_Charts.xlsx (based on Pivot_Table.xlsx file and linked to Base_Data.xlsx file such that whenever pivot_table.xlsx is refreshed the charts are also refreshed)
Also, can I make more than 1 pivot chart from the same pivot table? If so, How? If not, what is the solution?
Can you please outline the steps to do create these separate files? Thanks a lot in advance!
I am learning excel 2007 while working on the job. I have a simple query.
My base data from which I want to create pivot tables and pivot charts is stored in file called: Base_Data.xlsx
I want to create two separate files for pivot tables and pivot charts (based on the pivot tables) linked to the same data base as follows:
Pivot_Table.xlsx (based on the Base_Data.xlsx file)
Pivot_Charts.xlsx (based on Pivot_Table.xlsx file and linked to Base_Data.xlsx file such that whenever pivot_table.xlsx is refreshed the charts are also refreshed)
Also, can I make more than 1 pivot chart from the same pivot table? If so, How? If not, what is the solution?
Can you please outline the steps to do create these separate files? Thanks a lot in advance!