![]() ![]() Alternatively right-click on the Q1-Min data series and press Ctl-Y. right-click on the Q1-Min data series and select Format Data Series… > Fill|No fill. Repeat the previous steps for the lowest visible data series (i.e.This is done by right-clicking on any of the three Min data series boxes in the chart and selecting Format Data Series… On the resulting dialog box, choose Fill|No fill. Min) and set fill to No fill (and if necessary set border color to No Line) to remove the lowest boxes. Select the lowest data series in the chart (i.e. ![]() Select Design > Data|Switch Row/Column if necessary so that the x-axis represents the brands.Select Insert > Charts|Column > Stacked Column.Notice that the headings are included on the range, but not the last row. Once you have constructed the table, you can create the corresponding box plot as follows: Figure 2 – Box Plot table formulas Procedure ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |