• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Charting

Camilo Brun

New Member
Hello!

I have the following data:

Product, Product Rank, Product Category and Sales Figures.

I am having a tough time creating a pivot chart which will allow me to toggle through the Categories, without having to alse see the ALL the Products per Category.

Any suggestions on how to fix this?
I have enclosed a screenshot for reference!

Thanks in advanced!
 

Attachments

  • Untitled.png
    Untitled.png
    68.6 KB · Views: 8
Camilo

Firstly, Welcome to the Chandoo.org Forums

Can you post a real file, not a picture
Ideally describe what you have and then what you want as a product
 
Does it help to know that a pivot chart shows all of the data from a pivot table?

This means that you need to filter the pivot table to adjust your chart.

If you still need to show everything in the pivot table, make a copy of the pivot table which you filter, and make the chart from this filtered pivot table.
 
Back
Top