Make your dashboards interactive — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily
  • LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

Make your dashboards interactive

Get PDF file

by on
in Excel Training,Office Technology

Sometimes it’s too hard to include everything that a reader might want to examine for decision support. One way to present more information concisely is to add some interactive features, allowing the reader to dice, slice and customize what is being reported. Here are three tools that can do just that if you use pivot tables and pivot charts in building dashboards.

Slicers

Slicers are a way to filter your pivot table report by any field. Using multiple Slicers can also provide information as well as filter. Let’s begin with a single Slicer first. Here are the steps:

1. From inside the pivot table, click into the Pivot Table tools Analyze (Options in Office 2010) tab.

2. In the Filter group, click the Insert Slicer button. You can also find the Insert Slicer button on the Insert tab.

3. Select the field you wish to apply to the Slicer.

SlicersHINT: If you don’t see your fields, but a list of data connections, close the d...(register to read more)

To read the rest of this article you must first register with your email address.

Email Address:

Leave a Comment

Previous post:

Next post: