You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
In the last part of this 3 part series on slicers I’ll show you how slicers can be customized many different ways to create stellar looking reports.
Previously in this series:
Part 1: Easy (and Even Fun!) Data Exploration: Introducing Excel 2010 Slicers
Part 2: Interacting with Slicers
Slicers use styles the same way tables and PivotTables do, in light and dark options:
The default light style is shown below on the left. In order to use custom font, colors, and borders I can either start from scratch or make a copy of an existing style to tweak. Shown below on the right is a copy of the default light slicer style with a few changes.
In order to create this custom style, I first reduced the font of the whole slicer. Since the four button types (selected/unselected, data/no data) still used the original font size, I cleared the settings of each of these so they would inherit the font from the whole slicer, and then lightened the colors a bit. Finally, I decreased the button size.
With custom styles, you can achieve a wide variety of different looks:
Your custom styles show up in the ribbon, so you can quickly reuse them on other slicers. If you want to share your styles with others or use them in new documents, just save the file as a template the same way would for table or PivotTable styles.
Independently of the styles you use, you can also tweak the settings for the size of the slicer, the size of the buttons, and number of columns:
Let’s take another look at how slicers look when integrated with a report:
And don’t forget- you can apply different themes, which skin all your formatted cells, charts, tables, and slicers in one click.
Can you guys share the sample worksheet?
Horrible...horrible horrible. How much real estate does a pivot table have to take?
Is the Slicer object model exposed to VBA?
Realising the power is in pivot tables, but I can additionally see this being a very useful listbox.
This is what's needed to allow more real estate. Make your selections as bove images and then once the report has run the slicers autohide and your selection becomes a report header.
There's a Slicer OM and it looks fairly extensive.
Shouldn't the graphs be telling the story, and not the slicers? The data in the slicers tell a very small part of the story, yet the ability to give them so much formatting unduly adds to their importance, thereby detracting from the real stories the graphs are trying to communicate.
Also, if the slicers were put in the story optimally,
the color coding of the slicer would have the ability to match the color coding of the graph, where appropriate; and this would be done, not be a complete background color, but by a square bullet point, such as those found in graph labels.