Excel - Show Mean on Bell Curve - 5 Ways - Episode 1825b
2,257 views · Published 10 November 2013 · 4:08 · Indexed 23 October 2026
Channel: MrExcel.com · 2013 · Education
Microsoft Excel Tutorial: 5 Easy Ways to Show the Mean on a Bell Curve in Excel | MrExcel's Excel Podcast. Welcome to another episode of MrExcel's Excel podcast, where we explore different ways to use Excel and make your work easier. In today's episode, we will be discussing how to show the mean on a bell curve in five different ways. This is an addendum to our previous episode, where we showed how to create a bell curve in Excel. In episode 1663, we received a question on how to draw a line at the mean on a bell curve. In yesterday's episode, we showed one way to do it using an XY chart with two points. However, in today's episode, we will explore five different ways to achieve this. The first and easiest way is to use the drawing tools. Simply go to INSERT, SHAPES, and select a line. Then, hover over the mean point on the chart, hold down the SHIFT key, and drag the line straight down to the axis. Another way to show the mean on a bell curve is by adding a second series to the chart. Select the chart, click on the blue outline, and drag it to add the second series. Then, select the mean point and go to FORMAT, SERIES "LINE". From there, go to the LAYOUT tab and add ERROR BARS. Choose the option for MINUS only and enter the fixed value of the mean height. This will draw an error bar at the mean point. You can also achieve this by adding a second series with a height of 0 for the mean point. Then, go to the LAYOUT tab, select LINES, and choose SHOW HIGH-LOW LINES. This will draw a line from the highest point to the lowest point on the chart. However, if you want to use drop lines, you will need to create a copy of the chart and format it accordingly. This can be done by selecting the chart, holding down the CONTROL key, and dragging it to create a copy. Then, format the chart by removing the line color and filling the chart area and plot area with no fill. There are many ways to show the mean on a bell curve in Excel, and we have explored five of them in today's episode. However, some of these methods may seem like cheating if you are using them for a college class. But don't worry, there are still plenty of ways to achieve the same result. Thank you for tuning in to this episode of MrExcel's Excel podcast. Don't forget to subscribe to our channel for more helpful tips and tricks. See you next time! Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Adding a line at the mean (00:12) Using the drawing tools to insert a line (00:22) Adding a second series and using error bars (01:28) Using the "Show High-Low Lines" feature (01:50) Attempting to use drop lines (02:00) Creating a separate chart for drop lines (03:30) Lining up the charts (03:47) Different ways to add a line at the mean (03:57) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial An addendum to episode 1825 - several easier ways to add a line at the Mean of a bell curve: Drawing object, Error Bar, High-Low Line, Dropline. Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153648/
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920