• Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
  • Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
Quick Support
Book Demo

How to prevent slicers from ruining filtered charts in Excel

By admin on November 25, 2016April 19, 2019

 
 
 
 
 
Charts are used for creating a graphical presentation of the data.  A common practice when creating charts is to create them off of a filtered Pivot Table, usually a Top 5 or a Top 10 Pivot Table.  Slicers can then be added to interactively filter the data in the chart.
When filtering data with the slicer, the filtered data on the chart can be reset. That is why in this tip, we explain how to prevent slicers from ruining top 10 charts.
Applies To: Microsoft® Excel® 2010, 2013 and 2016.
The Pivot Chart was created from the Pivot Table below.

A slicer was then added to the Pivot Table.

If you use the slicer to filter the data below, it appears to work correctly.

However, when you clear your selection by clicking the filter icon on the top right side of the slicer as seen below, then the filtering is lost.

When you clear the slicer selection, Microsoft Excel clears the Pivot Table “Top 5” filter, including any other filters applied on the Pivot Table.
This causes the chart to reflect the raw, unfiltered data now appearing on the Pivot Table.

To prevent this from happening, ensure that, under your Pivot Table Options > Total & Filters Tab, the “Allow multiple filters per field” checkbox is ticked. To activate this option, right click on the Pivot Table, then select Pivot Table options.
Thereafter, filter your Pivot Table as required. The slicers will no longer get rid of your Pivot Table filters.

Slicers can then be cleared without clearing Pivot Table filters.

This is an essential tip when creating Dashboards that contain many filtered charts and slicers.
The post How to prevent slicers from ruining filtered charts in Excel appeared first on Sage Intelligence.

Powered by WPeMatico

Post navigation

Adding a report template to a new report in Sage Intelligence Reporting
Easily move a row or column in Excel

Recent Posts

  • Why Working In Excel Works
  • Alchemex Welcomes Velixo 6 For MYOB Advanced
  • Welcome to Velixo Reports Version 4.2
  • Part 3 of 3: Learn how to create a Management Pack in Sage 50cloud Intelligence
  • Part 3 of 3: Create and customize reports easily with the Financial Report Designer

Search

Contact Us

Phone: +61 2 9890 2339
Email: sales@alchemex.com.au
Address: PO Box 212, Deaken West, Canberra, Australia, 2600

Products

  • Intelligence Reporting
  • Velixo Reports

Services

  • Consulting
  • Training
  • Development

About

  • About Us
  • Partners
  • Blog

Support

  • New Ticket
  • Community (Coming Soon)
  • Knowledgebase

Phone: +61 2 9890 2339
Sales: sales@alchemex.com.au
Support: support@alchemex.com.au

Facebook-f Linkedin

© All rights reserved Alchemex Pty Ltd 2020

Made with ❤ by Unfazed Ltd