Get instant live Excel expert help and learn how to create a Pivot Table

“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

Hi, I made up a job list with a montly calendar from a template and an annual calendar. My job list is automaticly inserted in both calendars with an index. I would like to had a frequency to my calendar. In other words, I would like to make a job happen every X week. I added the row in my pivot table, but I can't figure it out how to make it to my calendar. Thanks
Solved by V. S. in 21 mins
I don't know how to make a Pivot table in Sheets
Solved by K. E. in 30 mins
I am currently trying to make a line graph based on a pivot table of data. I have two main issues: 1) Currently, my x-axis is Date, and it extends from January to December, just the months, no corresponding year. However, my data spans from September 2016 to December 2017, and so data points for the Fall, say, Oct 2016 and Oct 2017 are overlapping each other over the "October" tab on the x-axis. I want an X-axis that spans from September 2016 to December 2017. 2) I made two pivot tables from this data set: one for averages, and one for standard deviations. I want to figure out how to make a line graph from both so that I plot the value averages (as desired in Problem #1) and have corresponding standard deviation error bars for each data point.
Solved by A. H. in 15 mins
Pivot table won't give me the info that I need trying to figure out how to create the correct formulas to get what I need
Solved by I. U. in 26 mins
i want t know how to create pivot table and what is the use for it
Solved by A. Y. in 14 mins
I get a sales report from a customer. The data come in excel and because its so much two tabs are created. The column labels are the same. I know how to create a pivot table for one tab. I've tried to follow from on line creating a pivot table from multiple consolidation. The problem, however, it does not let me move the column headers like a single tab for creating a pivot table. I want one of the columns, the sku, to be the row and selling units to be the column. Thanks
Solved by G. U. in 13 mins
Please I need a guide on how to create a pivot table
Solved by Z. C. in 23 mins
i found this amazing excel dashboard on the web and i would like to create same chart as is at the botoom of the site, i have sales data in my excel file 6 salesman, and i would like it to be upon pivot table ican add slicer later. for now i am struggling with this pivot chart, can you guys guide me on how to create it?
Solved by V. B. in 29 mins
i need to know how to create relationships in pivot tables
Solved by K. L. in 28 mins
I would like to ask help on how to create pivot table, row must be Employee EDS and column should be prod hrs, alloc to docs and alloc eds.
Solved by C. W. in 21 mins