Register
Log In
Unanswered
Home
New Member
February 2, 2017
Offline
Hello everyone,
I was wondering how to add a slicer for the different fields that I added to the values zone. So, a slicer containing Room 1, Kitchen, Living room, aso)
I have data from multiple thermometers that I resume in a pivot table and pivot chart. I would like to be able to add a slicer that allows me to check / uncheck the different data.
I did have a look on the internet, but I couldn't find an answer to my question. Thank you in advance for your effort.
See Answer
July 16, 2010
Offline
It looks like your data isn't in the correct tabular format to support a Slicer that contains Room 1, Kitchen, Living Room etc. My guess is you have a separate column for each of these fields, as opposed to having a column called 'Room'.
You'd need to fix your data structure if you want a Slicer for the different rooms.
Mynda
Answers Post
Most Users Ever Online: 57
Currently Online:
9 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Sethu nath
Jose Alvarado
James Villapudua
Sheri O'Connor
Noreen Anagnos
Connie DeMercurio
Shanna Steinberg
Holly Seamons
Mark Cooper
David Matanana
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
