Simple Min Max and Average Chart in Excel

Learn how to create a simple chart to display min max and average values in Excel using a modified line chart. 👇
Check out my full courses and ebooks here
👉 www.howtoexcel...
DOWNLOAD the example workbook here
📖 www.howtoexcel...
SUBSCRIBE & get my 3 FREE eBooks
📧 www.howtoexcel...
CONNECT with me on social
Facebook: / howtoexcelblog
Twitter: / howtoexcelblog
LinkedIn: / john-macdougall
Thanks for all your support!

[@danielggonzalez5785]

To the point, clear example, no annoying background music, and ACTUALLY works. This is how a tutorial should be done.

[@HowToExcelBlog]

Thanks!

[@Byakkyo]

you're a lifesaver :"" thank you very much!

[@garikaizinumwe1248]

This is very interesting, i really enjoyed. More support from Africa (Zimbabwe)

[@siryoneyal]

I was looking for this method for couple of weeks. thank you for sharing

[@wayneedmondson1065]

Hi John.. excellent trick.. so clean and simple. Thanks for sharing it. Thumbs up for How To Excel!

[@emilyhigbee8328]

Exactly what I was looking for, thank you!

[@darrylmorgan]

Really Nice Clean Effective Chart!Thank You For The Tutorial John :):):)

[@HowToExcelBlog]

No problem Darryl.

[@duncanwil]

nice, clear, simple and very effective

[@HowToExcelBlog]

Thanks Duncan!

[@jedb9620]

Great video, easy to follow and helped out a lot!

[@HowToExcelBlog]

Glad it helped Jed 😀

[@stephaniemissb824]

very good explaination! thank you alotttt!

[@HowToExcelBlog]

No problem 👍

[@stefanwolf6272]

thank you very much. This video helped me a lot.

[@HowToExcelBlog]

Great!

[@andreead7283]

Very useful, thank you so much!

[@HowToExcelBlog]

Welcome!

[@MareeTeolanafo]

Excellent video. I will definitely create this chart.

[@HowToExcelBlog]

Good to hear!

[@ahmetkorkusuz3741]

Excellent, thank you very much, helped a lot

[@camhaw]

Such a great video!! Thank you so much!

[@abdihakinsuldan9513]

Thank you very much your uploads in advanced excel topics to share us

[@HowToExcelBlog]

You're welcome Abdihakin!

[@ezzeldinmostafa3264]

Awesome thanks.

[@HowToExcelBlog]

Welcome!

[@marcelonascimentosantos4272]

Muito interessante e leitura da informação eficiente! Obrigado pela Dica!

[@alexisantoniou3079]

Thank you!

[@HowToExcelBlog]

Welcome!

[@kerryslater5694]

Brilliant - thnks

[@rodolfot8318]

Hi. Bro. Excellent video. One question: Can I place the min-max average in a horizontal way. I am struggling to do it. I can only replicate a graph but the graph is always vertical

[@merbouni]

Good 👍

[@HowToExcelBlog]

Thanks!

[@AB-uy9vn]

Helped. But had to do mine differently as my values were going horizontally instead!

[@user-gf6lr9mw7f]

In the chart option, LINE is deactivated. Is it because of a version difference? mine is 2016.

[@HowToExcelBlog]

Hmm, not sure. I'm on Office 365.

[@alirzaorujov4839]

I've the same issue. did you fix it?

[@ninar.1956]

hi! i had the same problem - mine was because i had accidentally selected a scatter plot and not the 2D line plot he uses. for that one it should be activated