Get instant live expert help on I need help with two way data table

“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

using a two way chart to create a data table
Solved by K. H. in 16 mins
I have three tables on three different worksheets. One table is an input table where the data is entered, and the other two tables use the data from the input table to make calculations. Is there a way to get the calculation tables to autoexpand when a new line of data is entered into the input table without using VBA?
Solved by O. A. in 29 mins
I would like to create a third table where the calculated values are a result of dividing data in pivot table 1 by data in pivot table 2. I want to do it this way so when I move rows around in the first two tables and the first two tables adjust, I would like the third table to adjust in similar fashion so I don't have to deal with manual adjustments.
Solved by G. H. in 27 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
I have two table with figures in two separate worksheets and want to get one worksheet where all the data is summarized in one table - and where I can calculate the variations.
Solved by E. F. in 19 mins