Likert question on excel
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?
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? Read More