PDA

View Full Version : Pivot chart help



tommy1234
08-23-2011, 11:54 PM
Hello
i have an excel file which contain pivot table with data on my company
i need to be able to create several different pivot charts based on the same pivot table. :banghead:
i can't choose the chart series without changing the pivot table values.
i want to create a pivot chart for BL & DLQ, Inventory & Surplus and more.
the data sheet contain few rows, just for the example.
i need to finished this by the tomorrow morning.
Please help

thank you

Aflatoon
08-24-2011, 04:04 AM
You cannot achieve that with one pivot table I am afraid. You will require one table per chart, or you will have to use normal charts, which can get rather complicated to keep synchronised with your pivot table.