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. …...more
...more
Show less