# 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

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
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