SOLVED

Pivot Chart 4 columns, set responses to 4 questions

%3CLINGO-SUB%20id%3D%22lingo-sub-2329880%22%20slang%3D%22en-US%22%3EPivot%20Chart%204%20columns%2C%20set%20responses%20to%204%20questions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2329880%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFeel%20like%20I'm%20going%20crazy%20with%20something%20that%20should%20be%20simple%20but%20which%20never%20seems%20to%20work%20for%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20data%20that%20is%20set%20out%20like%20so...%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22table%20for%20pivot.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F278658i62D2F6344173F915%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22table%20for%20pivot.png%22%20alt%3D%22table%20for%20pivot.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20create%20a%20pivot%20that%20looks%20something%20like%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22pivot%20and%20fields.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F278659i1A2874A1F10D71A6%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22pivot%20and%20fields.png%22%20alt%3D%22pivot%20and%20fields.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EYou'll%20note%20that%20the%20counts%20are%20wrong%20in%20the%20above%20example.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22chart.png%22%20style%3D%22width%3A%20813px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F278660iCDE89C97A8ACEFF3%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22chart.png%22%20alt%3D%22chart.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20this%20is%20how%20I'd%20like%20the%20chart%20to%20look%2C%20basically%2C%20but%20I%20can't%20get%20the%20counts%20to%20be%20accurate.%20What%20am%20I%20missing%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20attached%20sheet%20to%20give%20example.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHelp%20Please!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2329880%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2329971%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Chart%204%20columns%2C%20set%20responses%20to%204%20questions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2329971%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F949996%22%20target%3D%22_blank%22%3E%40Davidm54%3C%2FA%3E%26nbsp%3BUnpivot%20your%20data%20first.%20Then%20create%20a%20pivot%20table%20and%20pivot%20chart.%20See%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2330011%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Chart%204%20columns%2C%20set%20responses%20to%204%20questions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2330011%22%20slang%3D%22en-US%22%3EThank%20you!%20That's%20gonna%20extrapolate%20to%20a%20whole%20lot%20of%20other%20charts.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Contributor

Hi All,

 

Feel like I'm going crazy with something that should be simple but which never seems to work for me.

 

I have data that is set out like so...

table for pivot.png

 

I want to create a pivot that looks something like this:

 

pivot and fields.png

You'll note that the counts are wrong in the above example.

 

chart.png

 

And this is how I'd like the chart to look, basically, but I can't get the counts to be accurate. What am I missing?

 

Have attached sheet to give example.

 

Help Please!

2 Replies
best response confirmed by Davidm54 (Contributor)
Solution

@Davidm54 Unpivot your data first. Then create a pivot table and pivot chart. See attached.

Thank you! That's gonna extrapolate to a whole lot of other charts.