Likert question on excel

[jfune1]

I made a survey for school using forms. I like the graphs provided after the surveys are done and I'm trying to use those graphs in excel, to be exact the likert graph but I cant seem to find out how to do it on excel. When ever I try to do the stacked bar graph it doesn't add up how it has it on forms. The title of the question is the only variable that comes on on everything like my x-axis, y-axis and key variables. Any way I can copy and paste the graphs already provided in forms onto excel? Or does anyone know the trick to use that specific formula in excel to do it?

[#2]

Hi @jfune1 

I attached sample charts created on survey data. Data refresh in the chart automatically as you change your data selection.

I regularly create these charts with the following tool. Hope you will like it.

You can check here for Microsoft Excel & Office 365.

And if you are comfortable with Google Sheets, you can find it here.

Thanks

Likert Scale Chart for survey data

Few more survey charts.