Min/Average/Max column Chart

In this Excel charting tutorial, you will create the Min/Average/Max column Charts in Excel. You have to create some data for the same.

Preparation of min max average data for a chart

Please find below the sales data for a week for six items:

Max Chart data table

Let us insert 3 rows for max, min and avg values:

rows for max min and avg values

Now we have to use formulas to calculate the Max, Min And Average as shown below:

Max: =MAX(B5:B11)

Min: =Min(B5:B11)

Avg: =Average(B5:B11)

formulas to calculate Max Min And Average

Max Chart round average formula

max formula

min formula

Inserting a min max average chart

Now we have the Max, Min And Avg data for all items. Let’s create the column chart now. Select this data:

Max Chart select data

Create a 2d column chart:

Create 2d column chart

It will create the chart as shown below:

Max Chart basic chart

So for each item, we have the Max(blue), Min(grey) and Average(Orange) bars as shown.

We can also convert this to a line chart if required as well. Right-click on the chart area and select “change chart type”.

Max Chart change chart type

By following these steps, you can create a column chart in Excel that displays the minimum, average, and maximum values for a set of data. This can be a useful way to visualize and compare data and draw conclusions from it.

See also  How to Make Normal Probability Plot in Excel