Get instant live expert help with Pivot Tables

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I want to learn how to create a pivot table in excel 2010, add slicers, Vlookups and charts
Solved by D. B. in 15 mins
Hi, I need help activating the slicer function for Pivot Tables
Solved by K. E. in 23 mins
Color changing charts based off of weight goals for the day and week. every week the goal weight will change. also how to use pivot tables and graphs that update automatically from that. etc.
Solved by T. F. in 23 mins
I was working with pivot tables and have a good understanding of how to build. One problem I’ve run into and can’t seem to solve is the dates in my filters. One of my filters, The Revised Promise Date and Actual Shipped Dates shows the detail date, IE 3/10/17, and allows me to filter. The dates I need like this are using the Original Promise and Need Dates as filters, those only allow me to filter by Month.
Solved by C. J. in 16 mins
The identical value in the data is seemingly arbitrarily split into two columns in the pivot tables. On the attached workbook, the red worksheets contain the data; the other colours are the pivot tables. As an example, I checked each cell containing the value "All" using the "=ISNUMBER" function. All returns were "FALSE", which if I understand correctly means that the value is text. This is as it should be. The purple worksheet "Lecturer totals T1" contains two columns for "All", "Lecturer totals 01-17" contains two columns each for "BaL" and "HLS" "Lecturer totals T2 & 3" contains double columns for all these three values. The same is true for the equivalent green "Faculty totals" and orange "Student totals" worksheets. How can I ensure that the pivot tables only contain one column for each of these values?
Solved by E. D. in 13 mins
Hi. This is quite hard to explain but hopefully the document will help! I have a s/sheet looking at a five year replacement plan for their PCs. I have a list of Locations (Labs) in a uni that contains the number of machines, how much it will cost to replace and a year that (1-5). At the moment they were populated manually. But if they decide they want to change, for example Lab B from the first year to the 3rd, it then needs to be done manually. What I'd like to be able to do, is, if the year is changed in column E, then the boxes / fields to the right get updated. I know I can do this with multiple pivot tables, but know that it could also be done with formulas. In G5 for Year 1, I have used the Index and Match functions to return Lab B. I'm guessing I might need OFFSET, (which I don't know much about as yet) but before I went ahead and researched it all, thought I would ask. Current formula (in G5) here is: =INDEX($B:$B,MATCH(1,$E:$E,0)) Thank you.
Solved by I. U. in 23 mins
From a large database of events occuring at multiple dates and times I am trying to determine how many times an event occurs within a certain amount of time of another event (i.e 15 min apart or 30 min apart), additionally I'd like to figure out how many times in 15 min 4 events happened, 3 events happened, etc. I've tried creating pivot tables but it still doesn't simplify it as much as I'd like...Any suggestions
Solved by S. S. in 30 mins
I recently learned how to utilize pivot tables, but I cannot maneuver my values to show what I am looking for.
Solved by I. E. in 25 mins
how do i correctly use vlookup and pivot tables for my aat level 3 exam
Solved by B. Y. in 30 mins
I'm trying to work on sumif functions and pivot tables.
Solved by T. J. in 16 mins