Easy (and Even Fun!) Data Exploration: Introducing Excel 2010 Slicers

re: Easy (and Even Fun!) Data Exploration: Introducing Excel 2010 Slicers

naseemmk — Mon, 21 Feb 2011 07:09:00 GMT

Very very impressive..... it will be good if u attach a sample sheet......

re: Easy (and Even Fun!) Data Exploration: Introducing Excel 2010 Slicers

Sam Rad — Tue, 29 Sep 2009 22:28:44 GMT

Posting for karen, she is having trouble leaving comments:

To address some of the comments here:

@Sergei

Office 2010 is coming in the first half of 2010.

@John

First issue - You might be able to get your slicers to work- after you save as .xlsx, try refreshing your data (Data > Refresh All). Also, make sure you're not including new items in the manual filter. (Row labels > right click the field > field settings > Include new items in manual filter should be unchecked).

Second issue - Could you clarify what you mean by default not to new series vs collectively together? When I create a PivotChart with every year as a new series - let's say 2001 had sales of 1, 2002 had sales of 2, and 2003 had sales of 3 - If I select 2002 and 2003 in slicers, the total would be "5" as expected.

@observer

You can change slicer formatting to whatever colors you wish, and you select them independently of what chart colors you're using (they don't match up automatically). They can be formatted to take up as much or as little space as you want (see upcoming blog post for examples of this). You can also hook up a slicer's formatting settings to a checkbox with a macro.

re: Easy (and Even Fun!) Data Exploration: Introducing Excel 2010 Slicers

observer — Sat, 26 Sep 2009 19:31:06 GMT

How much formatting do the slicers allow for?

In the example, they seem to be taking up way more space than they deserve.

Also, do the slicers allow for a checkbox on/off display format, where clicking the slicer rectangle area turns a checkbox within the rectangle "on" or "off"?

In the report's pie chart made up of Mountain Bikes (blue), Road Bikes (red), and Touring Bikes (green),

wouldn't it make more sense to have the color of the slicer match the color you see in the pie chart?

Similarly, in the line chart the colors are blue for Europe and red for North America, yet the slicer color for both of them is green?

Wouldn't it make more sense to have a bullet-point color box inside the slicer rectangle instead of giving the slicer an inordinate amount of attention with the vivid background colors?

And is there no built-in ability to match up slicer color with chart color?

re: Easy (and Even Fun!) Data Exploration: Introducing Excel 2010 Slicers

John — Fri, 25 Sep 2009 02:35:26 GMT

I like Slicers and they can be a great boon however I've noticed they are bit finicky.

First off I had a large spreadsheet in .Xls (

re: Easy (and Even Fun!) Data Exploration: Introducing Excel 2010 Slicers

Matt Bickford — Thu, 24 Sep 2009 12:15:05 GMT

Can't wait to tinker with that!

re: Easy (and Even Fun!) Data Exploration: Introducing Excel 2010 Slicers

Sergei — Thu, 24 Sep 2009 02:44:49 GMT

It looks very impressive. When is it due to release?

Thanks,