![]() ![]() On your keyboard, press the Delete key, to remove the legend.Click on the chart's Legend, to select it.Next, follow these steps to remove the legend, which isn't needed Choose No Outline from the list, so it isn't visible in the chart.Next, click the drop down arrow for the Outline colour.In the pop-up menu that appears, click the Fill drop down arrow.In the East column, right-click on the Box 1 - hidden series.The chart should have 2 stacked columns now - East and West.įirst, follow these steps to hide the bottom series (Box 1 - hidden) in the stacked columns In the Data group, click the Switch Row/Column command, to get the box series stacked correctly.On the Excel Ribbon, go to the Chart Design tab.If the chart shows 3 stacked columns, instead of 2 (for East and West), follow these steps to fix the problem In the Charts group, click Column Chart, then, under 2-D Column, click Stacked ColumnĪ chart is added to the worksheet, with stacked columns To Fix the Box Plot Chart:.On the Excel Ribbon, click the Insert tab.Select the blue data cells and labels, E10:G12. Select cells E3:G3 - the heading cells. ![]() The completed worksheet with data and formulas, is shown in the screenshot below.Ĭreate the Box Plot Chart To start the Box Plot chart: Screenshot, which shows the five-number summary.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |