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

I need help with my MIS homework using pivot tables
Solved by B. L. in 14 mins
I have a line chart created with 3 series (data sources) total, from 3 pivot tables. I also have 3 filters for each pivot table (the same filter for each table). My issue is that my date ranges on tables #2 & #3 are not showing blank data and keeping the date list the same when I filter the pivot tables. I have selected the Pivot table Display Option to 'Display item labels when no fields are in the values area' and it is doing that for the first pivot table, not for the others. The setting is greyed out for tables #2 & #3 and still checked (although not displayed).
Solved by Z. Q. in 17 mins
I created Pivot tables in a worksheet out of Macro. I would like to change some Pivot table headings like "Column Label", "Sum of -----" wherever they appear into some other text or value. Not able to do. pl help
Solved by X. S. in 16 mins
Hi - I am trying to fix a problem in a budget spreadsheet I created. I have a tab where all my master data is stored (hundreds of line items with different columns for categories, locations, etc.). I have created pivot tables to show comparisons of those categories, but then I'm also trying to do an overall budget view on one tab. I had linked the cells back to the pivot table charts, but when I refresh the pivot tables, my data in the overall chart doesn't update. So, how do I summarize 200 lines of data into multiple categories in one table with the sum of the budget items for each?
Solved by I. B. in 27 mins
I have a data sheet and need to change dates/times from UTC to PST and then create pivot tables for data analysis.
Solved by C. H. in 13 mins
Help creating two pivot tables (one for national and other for NV) that show average length of stay which is done by dividing column F and H
Solved by V. E. in 26 mins
I need assistance with basics of pivot tables in excel I can send you the spreadhseet
Solved by K. A. in 29 mins
I have three pivot tables which I want each time I update the pivot, it should automatically update a summary sheets. how can I achieve it.
Solved by S. S. in 25 mins
I need to learn how to create pivot table in excel from a very complex data set with bandwidth, locations etc...
Solved by T. A. in 16 mins
I am trying to create formulas off of pivot tables and and using abs formula in excel, is there a workaround to be able to drag a formula down and have the data translate to each row?
Solved by O. E. in 26 mins