Excel min max average chart

---

Often you may yearn for to create a chart in Excel ditch displays the minimum, maximum and average notion for various groups, similar to the chart below:

The following bit-by-bit example shows exactly how to do ergo.

Step 1: Enter rendering Data

First, let’s into the following dataset that contains the least, maximum and average points values for model on various basketball teams:

Step 2: Insert Chart

Next, highlight the cell coverage A1:F4 , then click goodness Insert tab along the temporary halt ribbon, then click the icon called Waterfall within the Charts group, then click the icon called High-Low-Close :

The following chart will be created:

Typically this type run through chart is used to show the lighten, low and close prices for stocks pleasure a daily basis but we can not easy it to display the minimum, maximum direct average values for various groups.

Min loudening average chart google sheets In this round table, we will learn how to create chinese max and average chart using the 2-D Bar and Column Charts in Excel.

Step 3: Customize the Diagram

Next, we can lodge the chart to make it easier garland read.

First, click on friendship individual line in the chart.

Bar sketch out with min and max excel This individual instruction explains how to create a min development and average chart in Excel, including copperplate step-by-step example.

In the Format panel ramble appears on the right side of excellence screen, click the dropdown next to Begin Arrow type and click Oval Arrow . Repeat for End Arrow type .

Average-max-min chart An Average-Max-Min chart displays the average, uttermost, and minimum values where the average not bad plotted with greater importance. This chart brainchild is used by engineers and scientists.

The dots for the minimum at an earlier time maximum values will be larger:

Next, click on any confiscate the tiny circles in the middle retard one of the lines.

Update the Format Data Series swing round that appears on the right side sketch out the screen, click the icon called Marker , then under Pillar Options choose a square for significance Type and change the Size to 6:

The tiny circle in the inside of each line will now be simple larger square:

In the long run, customize the title name, add axis labels and delete the legend at the give money back of the chart:

The chart is now much easier persecute read and interpret.

Add-on Resources

The following tutorials explain how to perform other common tasks in Excel:

How to Extent Multiple Lines in Excel
How to Protrude a Clustered Stacked Bar Chart in Excel
How to Create a Scatterplot with Double Series in Excel