Excel Pivot Chart Problem

  • Thread starter Thread starter Sumit Walia
  • Start date Start date
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
 
In any work with Pivot Tables it is far easier to make adjustments to
your base data table by adding calculation columns.

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