Hello All,

I was wondering if it's possible to combine two Pivot Tables in Excel into one Pivot. Ultimately, what I am trying to do is create a Pivot Chart (Line Chart) that displays three different sets of data derived from two fields in my Raw Data, and the only way I can think of going about doing this (without Macros and without losing data) is to create two different Pivot Tables from the same data and then combine the results of those into one Pivot table that the Pivot Chart would be based on (hopefully that made as much sense to you as it did in my head ;-) .

So far, I can't seem to find a way to accomplish this, and will probably need to write a script that reorganizes the data the way I need it, but I figured I would check here first, in case someone else found a non-macro solution.

Thanks.

Regards,

William