Microsoft Office Tutorials and References
In Depth Information
If you change the value in cell A1, you must respecify the filter criteria for column B be-
cause the rows will not hide automatically. Just click the filter icon in the column head-
ing and then click OK. The example uses a table Slicer, so clicking the 0 value applies
the filter. Add a Slicer to a table by choosing Table Tools ⇒ Design ⇒ Tools ⇒ Insert Slicer.
Although this example uses a table (created using Insert ⇒ Tables ⇒ Table), the technique also works with a nor-
mal range of data as long as it has column headers. Choose Data ⇒ Sort & Filter ⇒ Filter to enable filtering.
Identifying maximum and minimum values in a chart
Figure 17-12 shows a line chart that has its maximum and minimum values identified with a circle and a square,
respectively. These identifiers are the result of using two additional series in the chart. You can achieve this ef-
fect manually, by adding two shapes, but using the additional series makes it fully automated.
This example is available at this book's website. The filename is identify max and min