Hi All,
Does anyone know how to keep Chart filtered to Top 10 after using slicer?
What I am saying is that I created a pivot table and filtered Value to Top 10, than created a pivot chart off that table, and than slicer.
Now, every time I used slicer that Chart gets messed up ... it sort of "unfilteres" that Top 10 values and instead displays as many rows as chart size fits.
Does any one know what do I need to do to prevent this from happening?
Thanks much.
Does anyone know how to keep Chart filtered to Top 10 after using slicer?
What I am saying is that I created a pivot table and filtered Value to Top 10, than created a pivot chart off that table, and than slicer.
Now, every time I used slicer that Chart gets messed up ... it sort of "unfilteres" that Top 10 values and instead displays as many rows as chart size fits.
Does any one know what do I need to do to prevent this from happening?
Thanks much.
