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 to great a report with Pivot tables and charts to track project counts, milestones, and completions. I am not good with this kind of stuff.
Solved by K. D. in 11 mins
hi guys, pls help me to find solution with my issue. Before everything was working so well. Even Microsoft cannot help me with this issue during remote session. I worked on excel spreadsheet, created pivot table. always i send to my boss sales analysis using pivot table but now in preview he cannot see data, it is completely empty but database it is still visible. He needs to save file and then when he opens it everything is visible. but a lot of time he use only his cell phone and he is not able to save it, so i am trying to find way what happen with excel...pls what to do when i want to preview my excel file to see all pivot tables
Solved by V. U. in 18 mins
I need some pivot tables for my project that I can also convert to charts
Solved by T. S. in 27 mins
I need to create metrics from a spreadsheet, some sort of dashboard perhaps using Pivot tables or Chart. I have a file but would like help, because it's data that's work related.
Solved by I. F. in 30 mins
hi i need some help information in pivot tables, somebody can help me on that?? Thanks
Solved by O. Y. in 16 mins
Need some help with some Pivot tables for my project
Solved by K. E. in 15 mins
I have two tables with the following columns: a) Table 1 with following columns: No, Country, State, Site, Site Category, Shift b) Table 2 with following columns: Site, Vertical I want to create a pivot table with these two tables. I want to link the sites from Table 1 with verticals from table2. The columns in the two table are not the same. The two tables are present in two different worksheets I want to know a feasible way of linking these two tables using Pivot tables. It would be really helpful if you could provide a step by step process for the same. Looking forward for your response Thanks!
Solved by E. D. in 30 mins
I need the table to be formatted in a way were I can select a particular company and get the info only for that company. Then have be able to change it via pivot tables maybe where I can get the totals for the amounts of shares for instance
Solved by V. S. in 11 mins
I need help completing an excel spreadsheet with pivot tables. I have an old table completed by a previous employee but need to add some cells to it. It's well above my skill level....
Solved by G. Q. in 19 mins
Hi I am trying to set the connection of a pivot table to an ADO connection as a work around for accessing password protected excel files. Currently I have code to change all pivot tables to a different connection. I want to be able to set the connection to an ADO connection instead so my pivot tables can access data from a password protected file. How do I do this????
Solved by I. S. in 14 mins