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.
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
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.