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

I need help with pivot table basics. I'm having trouble creating a ratio to add to my pivot table

Solved by E. H. in 24 mins

I'm having trouble adding a pivot column calculating a ratio in my pivot table

Solved by F. C. in 18 mins

I need to change a pivot table macro. How do I do this?

Solved by C. C. in 15 mins

in sheet 3 worksheet, how to change the ranking of product on the chart so the product that generate the highest revenue will be the first, just like the pivot table and pls recommend the suitable title for this graph

Solved by I. E. in 14 mins

Hi there,
I need the data in the pivot table "Raw Data" columns AJ-AM sheet to appear as displayed with the blank columns. Can you assist?

Solved by I. H. in 28 mins

I'm trying to group my frequency distribition table excel by the number of customers who purchased a specific number of items at their visit to the store. My row groups need to be 1, 2,3,4,5,6,7>
So how can I group all the 7 purchase and higher visits in 1 row?

Solved by M. H. in 25 mins

Ranking with pivot table and running an exceptions check for 'bye' competitors . Also, replacing bye competitors with following rank.

Solved by E. W. in 16 mins

I am using a pivot table for disbursements. I have a sheet in my workbook with account numbers for named accounts. For example, account 1 = payroll. In my checkbook (which is my source data), I use numbers for my accounts. How do I tell my pivot table to use the name of the account instead of the number? (So it says Payroll instead of 1 in my Row Labels? ) Hope that makes sense???

Solved by F. A. in 27 mins

Complex multiple pivot table extractions for a list of competitors that need to gain additional slots when certain names are in a given category.

Solved by O. J. in 13 mins

Hi there,
Is there a way to add multiple columns of data in a single pivot table?

Solved by B. Y. in 17 mins