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

hello Madam /sir i got little confusion about pivot table tools once i select pivot table column option tool will be displayed but there formula column hide in my excel how can i get ?
Solved by E. D. in 24 mins
I create pivot tables/charts from data extracted into excel. Each month I have to update the charts - so I extract the data from the software, cut & paste into the file to update the data source for the charts. But - it seems I have to select the data source and highlight the records to be included for each chart, each time I update! I tried to produce a 'dynamic pivot table' without success. Other answers have been when selected the data source select a much large area so you capture the new data pasted into it.... sorry not easy to explain!
Solved by S. U. in 19 mins
How to create power pivot tables? I'm working as a document controller in a big company. I need your support with the all excel expert. I know you are the best team which helps employees and students. Thank you and godbless excel expert!
Solved by Z. S. in 20 mins
I created the pivot table with certain data excel. i want to add more data to the excel file and automatically the pivot table should get updated. is it possible?
Solved by D. E. in 29 mins
Use first 10 rows of the Raw Data tab to work out your formulas and double check to make sure you are doing them correctly (try replacing them to see if you get the same results that are already there). Once you are confident they are correct, copy the formulas down to complete this tab. Make sure you use the Q.1 Pivot tab to complete and show your work to answer Question 1 in the Questions & Answers tab. Use the Q.2 Pivot for Question 2 and Q.3 Pivot for Question 3. You must use the built-in calculations in the pivot tables for your answers and not manually perform calculations (e.g. averages) afterwards on the pivot table data
Solved by V. D. in 26 mins
Have an existing pivot table that lists columns of data but also need users to be able to enter comments next to each row of data in this pivot table. What I need to do is add a text column within the pivot table that users can enter comments directly. This text column also needs to be able to sort with the excisitng pivot table.
Solved by D. S. in 23 mins
Have an existing pivot table that lists columns of data but also need users to be able to enter comments next to each row of data in this pivot table. What I need to do is add a text column within the pivot table
Solved by A. D. in 30 mins
In Pivot table, how to put 2 columns one by one if the first row label has more than 1 value in the 2nd column?
Solved by X. J. in 17 mins
how to make a pivot table? I need to make several ranges of numbers into groups.
Solved by K. S. in 24 mins
How to do a pivot table? I cant get to the right data source of my pivot table
Solved by X. W. in 19 mins