10 of 11Image
Once your data is in PowerPivot, you can easily visualize it back in Excel using PivotTables, charts or both. Here we see a chart bound to the PowerPivot model with our baby name data, featuring several “slicers” above and to the left of the chart.
Slicers let you filter your data and see the chart update automatically. Here we have filtered the query to show data only for the names Abigail and Allison, in the states of AZ, CA, CO and NY, between 1995 and 2005. The slicer at the top contains only girls’ names because we selected “F” (female) in the "Gender" slicer toward the upper-left.