Exam 77-420 Microsoft Excel 2013 5. Create Charts and Objects 5.2 Format a Chart: Modify Chart and Graph Parameters (Filter the Data)

Chart Tools -> Chart Filter -> Values Filter the Chart Chart FIlters is another way to focus on one part of the data. Say you wanted to look at the top two sales reps. You can Filter the Chart. 3. Try This: Filter the Style The Chart is still selected. Go to Chart Filter -> Values. Go to Categories. Select: Connie and Nikki (checked). Click Apply. What Do You See? Now the Chart shows only two Columns. The Columns have been resized to fill the Chart Area. OK, Take Off the Chart Filters The Chart Filters are still open. Go to Categories and Select All (checked). Click Apply.   Save, save, save. The Computer Mama sez: This is new to Excel and it works very well.