Excel Pivot Table and Chart - Inserting slicer for multiple display options

HI Experts

Hope you can help

I have some data converted into a pivot table in Excel that contains some multiple criteria  in terms of quantity, number of cartons per shipment and number of purchase orders that equates to these values.

At present, I set up a simple pivot chart for quantities and would like to insert a slicer that would allow me to choose between showing the quantity, number of cartons or number of purchase orders on the chart itself.

Ive tried altering the order of fields and even though the table contains the relative data, I cannot seem to get it to allow me to select the multiple options from one slicer  - only separate ones.

If you could give me some ideas of how I can do this I would be very grateful – I have attached the sheet

Jase AlexanderCompliance ManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ShumsExcel & VBA ExpertCommented:
Will attached help?
Jase AlexanderCompliance ManagerAuthor Commented:
Hey There

Thank you for the repsonse

I dont believe its an issue with the table although this is really helpful

The issue i have is when I create a pivot chart from this data, its really messy.

The only way I could display the chart / graph in a readble way was to only include the date, quantity and reference fields but I would ideally like to have a filter that I could use to choose between showing either the cartons or number of PO;s instead of the quantities on the graph.

The only way i could do this is by inserting separate slicers - one for quantities, one for cartons and one for purchase orders.

Can you do this from one slicer?
ShumsExcel & VBA ExpertCommented:
Instead of having both in one chart, rather create a separate pivot chart. please check in attached...
abbas abdullaCommented:
Please check the attached file PvtWithHelper sheet.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jase AlexanderCompliance ManagerAuthor Commented:
HI Abbas

Thank you so much for this

This perfect

Would you be able to show me how you did this ? I would definitely like to mirror this option in other reports I have planned

Many Thanks
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.