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

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 need to create a recommended pivot table in Excel on my mac but when I click recommended pivot table it doesn't give me any options of tables it just creates one.
Solved by E. W. in 17 mins
There is an Excel attached, which contains product sales for a period of time. I would like her to create a pivot table that allows us to look at unit sales and sales dollars by the various product groups. The item numbers contain lettering, which will help her identify the groups. Once the pivot table is complete, I would like her to summarize her findings and to see what conclusions she can draw as to why categories are up or down over the years.
Solved by D. E. in 12 mins
I put this data from a json file into excel through the new query option. some of the display names have 2 or more different values and id like to be able to display them all in one line under one name instead of 3 different ones but whenever i do pivot table it murges the the values with the same damage type instead of displaying them seperately
Solved by E. H. in 27 mins
When i try to change my date to a pivot table the data with the same type merges and i get this error Expression.Error: There were too many elements in the enumeration to complete the operation. Details: List
Solved by S. W. in 26 mins
I need to create dashboard containing 4 charts(pie or histogram or any) and pivot table data
Solved by D. H. in 23 mins
how to group the date by months in pivot table
Solved by Z. F. in 20 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
Hi I have attached a pivot table I created to get counts for a set of data. I am unable to figure out how to get the count of gender to categorize by male, female and unknown. It is only giving me the overall value for each of the rows and columns selected.
Solved by C. L. in 21 mins
Data is seemingly arbitrarily split into two columns in the pivot table, and I can't figure out why. In the purple worksheet "Lecturer totals T1" you'll see two columns for "All". On "Lecturer totals 01-17" you'll see "BaL" and "HLS" twice. On "Lecturer totals T2 & 3" there are two columns for each of "All", "BaL" and "HLS". On the green "Faculty totals T1" worksheet, "All" has two entries. There are similar cases in the other worksheets. I've tried applying the "=ISNUMBER" function to each of the cells containing "All" in the data (the red worksheets). These return a FALSE reading, which (if I understand correctly) means that they're text, which is what they should be. Depending on when you answer, I might not be able to continue the conversation before tomorrow around 0900.
Solved by Z. Y. in 29 mins