Pivot Chart 4 columns, set responses to 4 questions

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... I want to create a pivot that loo...

Pivot table example left handed.xlsx19 KB

Charting

excel

Riny_van_Eekelen
May 06, 2021
Davidm54 Unpivot your data first. Then create a pivot table and pivot chart. See attached.
Pivot table example left handed_rev.xlsx106 KB

Riny_van_Eekelen

Platinum Contributor

May 06, 2021

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

Pivot table example left handed_rev.xlsx106 KB

Davidm54

Brass Contributor

May 06, 2021

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

Forum Discussion

Pivot Chart 4 columns, set responses to 4 questions

Resources