Thread: Pivot chart
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nikki dawn nikki dawn is offline
external usenet poster
 
Posts: 4
Default 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