Charting Survey Results in Excel (Visualize Employee Satisfaction results)

Hi Leila, this is good work. On the display for data labels is it possible to display percentage values as well using the same format? Kindly advise

Ok, I missed a step, if there was a survey of 10 questions completed by employees from different companies, how do I sort the data to tell me how many employees from X company gave what response?

Please do this same thing, but for Power BI

You are an absolute champion👏👏

amazing, love you Liela .. you are my best teacher

Great video as always!!!

Do you have a video about comparing several years of survey data for the same questions?

Thanks

Is Paltier Tech add-in a paid package?

Why do we need to divide neutral category by 2?

What if we have 0 responses?

Very clear and useful. Thank you very much!

you are the best excel trainer so far, in my opinion!

any alternative if i could not download the Peltier tool ?

Hi, what if there are instance where it has 0 responses, especially for strongly disagree or disagree? still need to include negative sign?

help! why my data labels go missing when i apply the custom formatting to convert the negative values to appear as positive values?

I just subscribed to your channel. You are a gold mine of information. I am an apple guy but I have to use excel for work and MS complicates things in their instructions but you get straight to the point and say things in a way that even I can understand and that says a lot LoL

In fact your videos are really helpful to me, however I would be able to understand your teach much better if you could slow down little.

I need to know how to add the questions to the survey response. I am bringing data from a PDF. All that comes over from the PDF is the columns and when I try to either make a chart or a pivot table it will not work.

What do I do if I want the neutral labels?

Very good. Thank you

Hi, I am working on Employee Engagement Survey. Can you help me find the Employee Engagement score or Employee Engagement Index (formula) calculation on a Likert scale? I would be extremely grateful. Thanks

This was slightly too fast for me to be able to keep up. If it had a more simplified step-by-step approach it would be helpful to me, although I am still a novice in this area of Excel.

Hello Leila, how can this likert chart be created in Power Bi?

Thank you very much, so informative!

Your channel is a gold mine! Every time I need something about excel charts, I know I could always find something useful from your channel. Thank you so much, Leila! 😘

Can anyone please explain me how to sort the legend without this peltier add-on?

thank you, so much, I work from home and realized that you've become a part of my virtual IT team. Thanks for sharing your wisdom and knowledge!

Great video Leila, thank you so much!
For the people wondering how to add data labels for the "neutral"-part:

- Add data labels for the negative or positive 'neutral' stacks
- Right click on data label --> 'Format data label'
- Under 'Label options', select "Value from cells" and disselect "Value"
- Select the original 'neutral' values
- If desired, you can select the label position as 'inside base' or 'inside end' , or keep it at 'center' (whatever you think looks nice)

I hope this helps, it is somewhat difficult without visuals. Sorry for spelling/grammar errors, English is not my native language :)

Is there a way to show the combined values for neutral responses? (Since the process here involves dividing the neutral to 2 , and I would like to show only 1 value that adds the 2 neutral halves combined in the chart)

how do you add a male and female data on this graph?

Thank you, you helped me

did no one notice how excel flips her y axis order?

Hi, Leila do you have more such videos on charts for Data Analysis?

My stack order is not consistent in one series orange might be first and in others it's last. What am I doing wrong?

so fast

Cant't thank you enough! Helped me a lot in my bachelor thesis :)

thanks..

Hi Leila!
If we have only data for positive and negative numbers (right side and left side bars) how can we add data labels outside the bars as in case of vertical bars. Here we have only center, inside end and inside base but there is no outside position option.
Example be comparison of male and female age for various classes.

Hello Leila, it was great learning those charts in Excel, but is there any ay we can do this in Power BI, that would be really helpful

many tnx. great tutorial

Great video, Leila really helped with my science research study. ngl sis talks fast so i had to set the playback speed to 0.75x lol

Hi Leila, is there a free download of the Peltier Tech Chart Utility package? Thank you

Hi Leila, how is it possible to have the results per department charted?
Satisfaction rate:
Dept. X 10 (employees) -> above 80%, 5 -> between 70 & 80%, 3 -> below 70%
Dept. Y 20 (employees) -> above 80%, 12 -> between 70 & 80%, 5 -> below 70%

Info to be included in the chart: department names, multiple option names,, number of employees