![]() The chart's Mean calculation as displayed on the Box & Whisker chart is calculated using Excel’s AVERAGE function as follows: F6: =AVERAGE(Data) I started calculating these values in F6, so have provided the appropriate cell references before the formula during the calculations below: MEAN (represented by the x on the chart) We will now generate each of the Box & Whisker chart values which get plotted in the chart: Right click the blue fill and change it to a lighter blue (so you can see the values)Īfter making these changes, your readable box plot should look like this: Proving the Box & Whisker Chart Calculations.Change the Chart title to “Query Refresh Times (seconds). ![]() Go to Insert -> Recommended Chart -> All Charts -> Box & Whisker -> OK.Go to the Table Design tab and – on the left side – change the name of the table to “Data”.Select the data and press CTRL + T to turn it into an official Excel table.(Keep in mind that you can, of course, customize the values displayed, which may change the calculations used below.) The data set we’ll use is a short one, containing 10 observations representing Power Query refresh times:Ĭreating the chart is fairly straight forward: Creating the Box and Whisker chartįor this post, we are going to create a simple Box and Whisker chart using the defaults that Microsoft provides. So just for fun, let’s build a quick Box and Whisker chart, then prove out the values that have been plotted. It helps me understand the methods, exact values plotted and allows me to really validate the output. Now I know that not everyone is going to want to do this, but one of the things that I find which really helps me understand complex calculations or visuals, is to manually replicate the values used.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |