MSGraph 2000 Add Z Axis

[AlCamp]

In Access97, using MSGraph 2000, I'd like to add a secondary
(Z?) axis plot to my Bar Chart.

My basic Bar chart works fine, and shows the count (y-axis) of 35 different
defects (x-axis) for a particular product.
I'd like to add a secondary axis (using a line instead of bars) to my
graph that would plot the Average defect count for ALL products.

It would seem as though I would need a seperate query for this secondary
axis...
as I can not see how to create one query for the chart that would yield
"individual" product defect counts AND "overall" count values.

Can someone get me going in the right direction on this?

Thanks in advance,
Al Camp

 

[AlCamp]

No need to respond to my question. After some hours of pondering, I
realize now why I'm going nuts trying to create a Bar/Line chart that
displays Individual Product defects vs. All Products Defects.

The epiphany concerns how Access provides data for a chart vs. Excel.
I'll try to explain...

The Data Series values in Excel can be independent of each other, such
as... a chart that Shows Individual Product Sales Quantity, Individual
Product Sales Dollars, All Products Sales Quantity, etc... etc... The basis
for each Data series can be completely different from the others, but each
will plot their value without regard for the others.

How Access presents data to a chart is completely different than in
Excel. My values have to be the result of a legitimate dataset (query), and
the examples above would not normally exist together in a relational
database. They are disparate values, and no query would yield those
graphable values. I'll have to go through some special "machinations" to
get my data into a dataset that's "presentable" to my graph.

Now I realize what I'll have to do to get my data ready for graphing...
and then the Line/Bar combination chart, and the Secondary Axis will be no
problem at all.

Thanks for your assistance,
Al Camp