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

Pivot Chart Slicer - dynamic axis

jshateach

New Member
I am summarizing quiz results from participants in multiple categories (gender and an age group) in a bar graph. The x-axis is the number of responses answered correctly and the y-axis is the number of responders with that many correct.

I don't want my x-axis to be dynamic when i switch between categories. For instance - I don't want "0 correct" to disappear when I select "Women" just because there were 0 women to miss all of them. Another instance - if I select "Men" and "Under 30" and there is only one participant under that category, I don't want the x-axis to JUST show "4 Correct". I want it to show "0 Correct" "1 Correct", etc.
 
Back
Top