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

Hello, I tried to attach my spreadsheet bit it is too large. I built a power pivot table with a customized formula and everything looked really good but when I try and update the information for the new day the only thing that comes up is the error #NUM!. I am struggling understanding why the formula works for data that was in the spreadsheet when I made it but any data that I update it with gives me the error.

I want to make pivot table between gender and net sales of the company please tell how to make it

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.

I am making a dashboard in excel with multiple pivot tables and slicers and would like to know how the tables and graphs can automatically extend without overlapping. Moreover I'm making charts/graphs with no default settings which I would like to save as templates but I don't know how to make them remain or extend when selecting other things in the slicers.