Simple Bar Graph : Use of Scatter and Column Chart.

Simple Bar Diagram:

Simple Bar Diagram , is the simplest way to represent the data.

So, while learning it on Excel, first we insert the scatter graph of the data and then insert column data. Let see step wise step.

Below is the data which we proceed to represent it on graph. First Select the data as in illustration.

Then , from insert tab, click on scatter "Scatter with only markers" icon.

Below diagram represent the scatter graph of data.

After pointing out the magnitudes of the observations, we need data to be represented by the heights of the rectangles.

For that, From insert tab again,  Click on Column "Clustered column".

And here, we get the representation of  "Simple bar graph".

You can do more work on formatting the graph for more presentable.

Like add data labels from layout tab:

Can remove Gridlines, from layout tab.

That's how we did it, prepared our simple bar graph.

Thank you!