Get instant live Excel 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

HOW TO DO CHART USING EXCEL AND HOW TO CREATE A PIVOT TABLE
Solved by K. E. in 16 mins
I need a pivot table to show Total profit, sub-totaled by each Product category, and Customer type.
Solved by E. F. in 26 mins
How do I get the same pivot table as the one shown here in this document?
Solved by E. L. in 30 mins
I'm working on a pivot table that will provide cross-tabulated results for a multi-part survey question, which I need to cross-tabulate against a second multi-part survey question. Each question has a number of checkbox answers, with respondents being able to check multiple responses. I want the pivot table to show the counts for each data cell. How do I create such a pivot table?
Solved by X. C. in 12 mins
I need to make a pivot table of multiple sheets that represent data about the same thing on different years. The columns are: Name/Position/Unit/Hours. There can be several rows containing the same combination of Name/Position/Unit, as the same person can have taken the position for several isolated periods within the year. I need to show sum of hours for each year. As I understand, to show that I need to have the relationship defined, for which I need column in those tables with unique values that I don't have. How can I create the pivot table I need?
Solved by K. D. in 30 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 don't know how to make a Pivot table in Sheets
Solved by K. E. in 30 mins
Currently using an excel spread sheet to create a database of parts and their parts numbers, as well as the contact information of who to contact to order the part. I have a pivet table set up and in column A i have all the parts going down, and then the plus/minus buttons are clicked to reveal the contacts/phone/email to get ahold of it, again this is all in column A via the compact form report layout. Next i am trying to find a way to insert addition information such as order frequency etc, in column BCDEF. I want them to be attached to the pivot table so that i can easily update and insert information. If i were to insert the frequencies next to the table but not in it, when opening the plus/minus' in column A this then throws the rest of the document out of wack and isnt aligned correctly. How would i go about inserting this information in a column connected to the pivot table and its corresponding parts without changing out of the compact view because of printing aspects and clarity.
Solved by F. C. in 12 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 change the chart style of the pivot table to Chart layout 1?
Solved by C. Q. in 15 mins