“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

the source data worksheet includes data with dates from 2015 and 2016. I want the pivot tables I create to be able to gather data from each year separately. How do you make that happen

Solved by M. H. in 29 mins

I cannot find pivot tables in excel. Could you please help?

Solved by Z. L. in 26 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

I want to create ROC curves using pivot tables but i dont know how to

Solved by V. Y. in 22 mins

Using Microsoft Excel Index function, Match function, CountIf function, SumIf functions and Pivot Tables, please answer the question in data sample.

Solved by A. H. in 27 mins

What are pivot tables for? When do you use them?

Solved by I. C. in 20 mins

I need help with formulas and possibly pivot tables.

Solved by D. J. in 16 mins

I need help to extend pivot tables in a spread sheet please see attached

Solved by A. A. in 18 mins

I need help with Pivot Tables / IF Statements / and Calculated Field.

Solved by D. S. in 24 mins

Hi, I have multiple pivot tables and want to know how to pull data for a person's name without using the drop down option several times

Solved by E. J. in 25 mins