N
nhsosu8185
I am trying to utilize the Pivot Chart form in Access. I am running into
some difficulties with the chart adding totals together and plotting them on
a line chart as if each value is stacked on one another.
the chart is laid out with values of the row being Yr field and Wk Field,
Series are several proble categories, the detail is count of occurences in
each problem.
When I have one or two of the series in the chart, it calculates fine, once
I add more than three it stacks them.
For example. Problem 1 value for 2005 week23 is 200, Problem 2 value for
same week is 150. Just these two, they plot out fine.
Add Problem type 3 at 300 and Problem 1 shows on chart at 650 even though
date point says 200, Problem 2 plots at 450 even though it show as 150 and
problem 3 plots out at 300.
Any body have any thoughts?
Help!!!!
some difficulties with the chart adding totals together and plotting them on
a line chart as if each value is stacked on one another.
the chart is laid out with values of the row being Yr field and Wk Field,
Series are several proble categories, the detail is count of occurences in
each problem.
When I have one or two of the series in the chart, it calculates fine, once
I add more than three it stacks them.
For example. Problem 1 value for 2005 week23 is 200, Problem 2 value for
same week is 150. Just these two, they plot out fine.
Add Problem type 3 at 300 and Problem 1 shows on chart at 650 even though
date point says 200, Problem 2 plots at 450 even though it show as 150 and
problem 3 plots out at 300.
Any body have any thoughts?
Help!!!!