Results 1 to 2 of 2

Thread: Pivot Chart Help - x axis formatting

  1. #1
    Neophyte 2012NASkater2012's Avatar
    Join Date
    Jul 2019
    Excel Version
    Excel 2016

    Pivot Chart Help - x axis formatting

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I've attached the excel for reference (sheet 1) - I am trying to create a pivot chart based on some survey results, but the x axis fields are not separating out how I want.
    The question I am trying to build a pivot chart for has multiple select answers (so out of the 4 answers, a person could pick choices "a, b, c, d" or "a and b", or just "b". I want answers a, b, c, and d as distinct fields on the x axis, and then each bar would correlate to the "Count" of each of these fields. However, the x axis is instead showing me a|b|c, a|b, a|b|c|d, etc. based on the answers that each person has selected, so now I have over 10 bars. How do I make the x axis separate out to just 4 bars?
    Attached Files Attached Files

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Ipswich, Suffolk, England
    Excel Version
    Office 365 Subscription
    Duplicate thread closed.

    Continue here, please:
    Enthusiastic self-taught user of MS Excel!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts