Sign in to confirm you’re not a bot
This helps protect our community. Learn more
Filtering Unwanted Data From Excel Charts
7Likes
10,150Views
2014Nov 25
One of the problems faced by business professionals when creating charts is having data that doesn't support the reporting objective. For example, a report exported from an accounting system may display monthly detail, quarterly totals, and an annual total, but the user wants to prepare a chart that presents only quarterly comparisons. Beginning with Excel 2013, you can filter data from your Excel charts, and in this tip, you will learn how to take advantage of this easy-to-implement feature.

Follow along using the transcript.

K2 Enterprises

5.09K subscribers