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

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