Charting Survey Results in Excel (Visualize Employee Satisfaction results)
April 18, 2019 Excel Charts
Find out how you can visualize survey results in Excel. This is specially good if you have conducted an employee satisfaction survey and you'd like to present the results.
Of course the chart can also be applied to any survey data that uses a Likert scale (which is based on people's attitudes or emotions to a topic). This can range from strongly disagree, disagree, neutral, agree and strongly agree.
I show how you can create a stacked bar chart, as well as a diverging stacked bar chart as shown on Jon Peltier's website here (https://peltiertech.com/charting-survey-results/).
Peltier Tech Chart Utility for Excel: https://peltiertech.com/Utility20/PeltierTechUtility.html
Link to Custom Formatting Blog Post: https://www.xelplus.com/excel-custom-number-formatting_1/
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/charting-survey-results-excel/
★ My Online Excel Courses ► https://courses.xelplus.com
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
-
2:15:56
Game On!
4 hours agoHappy Memorial Day! | Sports Morning Espresso Shot
11.7K7 -
1:48:03
The Podcast of the Lotus Eaters
7 hours agoThe Podcast of the Lotus Eaters #923
25.8K20 -
1:44:50
jeffahern
3 hours agoMonday Madness with Jeff Ahern (6AM Pacific)
17.8K2 -
25:18
CarlCrusher
14 hours agoCurse of the Skinwalker | The Ancient Mystery of Magic Mesa - Full Documentary | Part 5
5K1 -
32:00
Blue Siesta ASMR
19 hours agoASMR General Knowledge Quiz | 10 Questions Soft Spoken
8.86K4 -
13:38
JoBlo Horror Originals
2 hours agoWhat Happened To Texas Chainsaw Massacre (2022)?
8.17K1 -
10:50
Yarnhub
5 hours agoWW1 Balloon Buster and the Chinese Balloon
8.41K2 -
12:33
Degenerate Jay
1 day agoAssassin's Creed 2's Best Feature Changed The Series Forever
9.09K1 -
1:21:37
Roseanne Barr
2 days ago $103.27 earnedKevin Sorbo saves America | The Roseanne Barr Podcast #49
164K568 -
8:13:09
Akademiks
20 hours agoIs It OVER for DRAKE?? Industry and Fans Turned on him? Cassie Tryna not get CHARGED w/ Diddy?
96.3K169