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

i need to know how to create relationships in pivot tables

Solved by K. L. in 28 mins

i need help with pivot tables, my return on investment column is messed up

Solved by F. Y. in 14 mins

i need someone to get me through the basics of pivot tables

Solved by M. A. in 30 mins

presentation of data on pivot tables ,pie charts, and graphs

Solved by A. A. in 18 mins

I have 3 pivot tables, all from same source, where pivot 1 reflects all occurrences. Pivot 2 shows a subset of pivot 1 occurrences that also have any specified codes. Pivot 3 shows a subset of pivot 2, where it shows only a few of the codes from pivot 2.
I'd like to combine the graph this data in a single chart. Do i somehow have to link the 3 pivot tables (e.g. power pivot) in order to do so? I can provide screenshots or sample example of used pivots. The attached example is located in TAB7
Thanks

Solved by X. E. in 24 mins

I have 3 pivot tables, all from same source, where pivot 1 reflects all "occurrences". Pivot 2 shows a subset of pivot 1 "occurrences" that also have any specified "codes". Pivot 3 shows a subset of pivot 2, where it shows only a few of the "codes" from pivot 2.
I'd like to combine some data from each of these pivot tables in a single chart. Do i somehow have to link the 3 pivot tables (e.g. using power pivot, maybe?) in order to do so? I can provide screenshots or sample example of pivots. The attached example is located in TAB7
Thanks

Solved by O. C. in 21 mins

I want to create a interactive dashboard with slicers in excel 2010. I have charts that are already created without pivot tables. Is this possible to do with the existing charts that are not pivoted?

Solved by X. U. in 29 mins

Pivot tables not working. I can't make the data show up properly.

Solved by K. C. in 11 mins

Pivot Tables and Charts: I have an 'Actual Work' column that I need to plot (summed by day) according to the 'Actual Finish Date' and a 'Work' column that I need to plot (summed by day) according to the 'Earliest Finish Date'. I would like for the date fields to combine on the chart showing one set of dates, but have the data plot based on the dates specified above (Work with Early Finish and Actual Work with Actual Finish). I can see where it allows me to show two sets of dates on the X-axis but it looks confusing and cluttered. I'd like to consolidate those date fields. Is this possible?

Solved by I. S. in 22 mins

I've created 3 pivot tables and one regular chart with data from the first pivot table. I want to add the other two as new series' to the chart but I'm doing something wrong because the option to add under Select Data (Legend -series) is greyed out. Please help me figure out what I am missing when I created the pivot table and regular chart. Look at the % Comp Curve tab.

Solved by I. J. in 28 mins