Microsoft Office Tutorials and References
In Depth Information
Using Slicers as Form Controls
Figure 16-21: Quickly switch between Quarters, Years, Months, and Days.
Timeline slicers apply filters based on standard calendar years. In other words, Q1
means Jan, Feb, and Mar. However, if your fiscal year starts in October, your Q1 is
made up of Oct, Nov, and Dec. So the quarter slicers may not be as useful for your
organization. Currently you can’t force a slicer to adjust to your own custom fiscal
Timeline slicers are not backward-compatible, meaning they are usable only in Excel
2013. If you open a workbook with Timeline slicers in Excel 2010 or previous versions,
the Timeline slicers will be disabled.
Using Slicers as Form Controls
In Chapter 12, you discovered how to add interactivity to a dashboard using data modeling
techniques and Form controls. Although the techniques in that chapter are powerful, the one drawback
is that Excel Form controls are starting to look a bit dated, especially when paired with the
modernlooking charts that come with Excel 2013.
One clever way to alleviate this problem is to highjack the slicer feature for use as a proxy Form
control of sorts. Figure 16-22 demonstrates this option with a chart that responds to the slicer on the left.
When you click Income, the chart fills with income data. When you click Expense, the chart fills with
expense data. Keep in mind that the chart is no way connected to a pivot table.
Search JabSto ::

Custom Search