Excel Pivot Chart Problem

S

Sumit Walia

Hi,
I 'm working on a Pivot chart in which I need to show 2
things: Qty and avg. CT. which are to be shown on the Y-
axis.
On the axis, we have week nr.

But, Qty is with reference to a different week nr and Avg.
CT is with reference to another week nr.

How can I show 2 things on Y-Axis with different week
references on X-Axis.
In case of any clarifications, please let me know.

Thanks and Regards,
Sumit
 
B

BrianB

In any work with Pivot Tables it is far easier to make adjustments to
your base data table by adding calculation columns.

Regards
BrianB
========================
 
Top