Help: Adding / haveing / displaying a second datasource on to y Axis???

N

normanf

Hi there,

I have managed to display for each dapartment wastage over
a period of 12 month. Now I like to presen the wastage
produced in relation to actual production over the same
period.
My first attempts started of by creating 2 Crosstab
queries. I than created on query where as I incorporated
the 2 crosstabs linked on department.
The queries return the data well. Attempts to create a
chart from it failed as the program reply to complex data
failure message.

Are there any other ways to achieve the desired result?
Can you over lay 2 charts?? How would I go on creating the
chart programaticlly using VBA??

Any hints or comments are very much appreciated.

Kind Regards

Norman
 
Top