Microsoft Office Tutorials and References
In Depth Information
Normally, a chart doesn't display data that's in a hidden row or columns. You can use the Hidden and Empty Cell
Settings dialog box to force a chart to use hidden data.
Creating a box plot
A box plot (sometimes known as a quartile plot ) is often used to summarize data. Figure 17-10 shows a box plot
created for four groups of data. The raw data appears in columns A through D. The range G2:J7, used in the
chart, contains formulas that summarize the data. Table 17-1 lists the formulas in column G (which were copied
to the three columns to the right).