Excel VBA Slicer Selection

Slicers are one of the most attractive ways to show summary data.  Introduced in Excel 2010 slicers are a way to show a list of data as buttons on a page.

Clicking on the buttons enables you to isolate one item in a list of items.

The slicer above the summary table shows a summary (All).  Next to this table I want to show a chart displaying data stacked if All is chosen or a sigle region if one of those is displayed in the slicer box.

However, I want to do this so it is seem...

Read More
Tags , ,