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
========================
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Chart - Excel 2013 - Rotating Second and Third Lines of text onthe Horizontal Axis 0
Excel chart does not start at zero. 1
Remove the weekends from a pivot chart x axis 0
charts look different if you put in data into the x axis 3
graphs 1
Excel Charting Problem 2
if statement with vlookup 1
Reg: Preparing Charts using Pivot Data 6

Back
Top