i am trying to make a chart showing likert data
i wanted to show negative per/centages neutral for "indifferent" and positive %. how do i do that in pivot chart
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
charts
0
Discussion
Honestly, that's above my 'pay-grade' lol. Sorry :/ If you can provide a sample worksheet with a specific Excel related query pertaining to the data then it would be much easier to help.
don (rep: 1989) Apr 26, '17 at 9:09 am
I think i sort of figured out how they made it. I saw this http://peltiertech.com/diverging-stacked-bar-charts/ and loved the chart with 0 resting in the middle of the indifferent variable. i guess i need to $ to get it or cheat excel by making two separate columns for the indifferent values and separaating them with equal values. smtg like that. thanks though
anti Apr 27, '17 at 7:50 am