View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Mark Mark is offline
external usenet poster
 
Posts: 989
Default chart from pivot data, and sheet data?

Jon,

I've looked at your downloaed the zip of the dynamic chart...

I see what you're doing there.

I think it's complicated a little bit by the fact that one source is from
the pivot, and one source from the static capacity grid (I don't think I said
that before... the pivot data is extracted shop floor hours requirements, and
the static data is a capacity definition).

But, first, I'm not sure they need the chart to be dynamic... but it would
be nice.

I think it's doable, in a couple of ways. One would be to lump the capacity
data into the pivot, with a defining field... might run inot some issue with
that.

And another way woud be to do the series definition of the capacity
similarly to the dynamic series definition of the pivot data. Probably run
into a bump here and there getting that in, but it should work.

Thanks again for your suggestions.
Mark