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!”
Here are some problems that our users have asked and received explanations on
I need help on how to use pivot table in excel to fill in a sheet and also create a graph to compare the company's performance in 2016 vs 2017
Solved by A. S. in 17 mins
I need hep understanding how to do this particular pivot table and chart,
Solved by K. Q. in 15 mins
I am trying to make a schedule of employees on one sheet and have it show on another sheet a specific day of my choosing. Is there a formula or pivot table for this?
Solved by I. Y. in 23 mins
I am trying to group in a pivot table columns and sub columns, id like to see the piviot table columns the same as how the monthly tabs show an "extended travel" column with sub columns with "mileage" "meals" "hotel"
Solved by I. H. in 21 mins
Help with Vlookup and pivot tables. I have some information and need to find results using these methods for my work. There is a whole bunch of data that needs to be simply revised.
Solved by S. A. in 30 mins
I have a spreadsheet of Incident tickets with opened dates from all of 2018. I need to break down the tickets so that I can break it down into days of the week (Monday,tuesday,wednesday, etc) and then the average number of tickets opened for each hour of that day for the whole year (example - for monday 1am - 2 am - average = 4 tickets). I tried pivot tables but I can't format the days of the week correctly to show as monday, tuesday, etc.
Solved by B. H. in 19 mins
I have two value field columns in a pivot chart and I need to calculate a third column (percentage). Column A/Column B *100
I can't figure out how to do that outside of copying the values to a normal sheet and doing it manually. I would like to do it within the pivot table so the values update as the data changes.
I have tried calculated fields and I can't get it to work.
Solved by T. U. in 27 mins
what is pivot table? do you have any way to explain it simply?
Solved by F. C. in 22 mins
I need a formula where I can use a pivot table/chart and it will sort and count my data. What I want is to count the # of times a certain state appears in my data and then sort that into the 4 main regions of the country
Solved by M. Q. in 15 mins
I need to evolve a spreadsheet to include a new line item. It is a muti tab google sheet that is relatively complex and includes a pivot table on a summary page
Solved by B. E. in 29 mins