In this video, we’ll look at how to plot results from a survey question in an Excel bar chart.
Here we have data from a survey we ran recently. We’ve got around 3900 responses to the question “What version of Excel do you use most?”.
Let’s plot the data in a chart.
The first step is to build a summary table.
First, I’ll convert the data to an Excel table. This step is not required, but it will make the formulas easier to write.