Pivot chart
Hi,
I want to have multiple data (both bars and scattered.)
What I need is for Weeks 32 through 40, a Bar Graph of the backlog qtys vs.
units build qtys. I would like to have the components received to form
scatter lines against the bar graph. Is there a way to do this?
(In the big picture, what I am trying to do is evaluate how effectively we
are using the materials received by comparing what was available to us and
our output.)
I suspect that I set the data table incorrectly so the pivot table is
skewing it in some way.
Any help is appreciated. Thanks, Nikki
|