How to plot survey data in a bar chart

Tip: How to plot survey data in a bar chart

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.

Duration 
3:42
Author 

Leave a Reply

Your email address will not be published. Required fields are marked *