Office 2013: The Missing Manual by Nancy Conner & Matthew MacDonald

Author:Nancy Conner & Matthew MacDonald
Language: eng
Format: epub
Tags: COMPUTERS / Desktop Applications / Suites
Publisher: Pogue Press
Published: 2013-05-21T16:00:00+00:00

Filtering Chart Data

As you just saw, your charts aren’t married to the data they started out with. With just a few clicks, you can change the selection of data that appears in your chart.

Excel charts also have a complementary feature called filtering. Filtering temporarily hides some of the information that belongs to your chart. This comes in handy if you want to dig deeper into your data and search for patterns, without worrying about scrambling your original chart. When you finish exploring your data, you can quickly flip off your filtering settings and return your chart to normal.

You can filter a chart two ways. The first is to use table filtering. In this case, you pick new filtering conditions from the column headers of your table, and the chart automatically adjusts itself to use the currently displayed data.

The second approach—the one you’ll focus on in this section—is to use chart filtering. Chart filtering provides fewer options than table filtering, but it works with every chart, even if your data isn’t in a table. Chart filtering has at least one other big advantage over table filtering: It lets you keep all your data visible on your worksheet, even when you plot only some of it in your chart.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.