second try: Stacked, Clustered Columns in Pivot Chart

[Rob]

I posted this a couple of days ago... no response. Anyone have any
insights? Thanks
Rob
----------------------------------------------------------------------------------------------------------

I need to create a stacked, clustered column chart. I've seen some
tricks to allow this to be done in Excel (using a secondary axis), but
I don't know if it can be done in Access.

I have no problem getting the data to be graphed, I just don't know how
to graph it.

An example of a stacked clustered chart might be the number of people
who watch The Sopranos, broken down by year, gender, and age. The
category axis would be 'year,' the clusters would be 'gender', the
stacks would be a breakdown of 'age', and the value axis would be the
count. On its side, a chart might look like:

2003 M 3333335555577
2003 F 33335577
------------------------------------
2004 M 3333333335555777
2004 F 33333557
------------------------------------
2005 M 33333335555555557777
2005 F 3335555557777

where '3' means millions of viewers 30 and under, '5' means 30-50
years, and '7' means 50-70 years.

Can this be done?

 

[Nick 'The database Guy']

Hi Rob,

I don't think that it can be done unless you, and it should not be
hard, manage to change the data in to real numbers so it looks more
like.

Year ¦Sex¦Under 30 ¦30 - 50 ¦50+
2003 M 6000000 5000000 2000000
2003 F 4000000 2000000 2000000
2004 M 9000000 4000000 3000000
2004 F 5000000 2000000 1000000

Then I think that you will find it quite easy.

Good luck

 

[Rob]

Hmm. I can certainly build a crosstab query to get the data to look
like that. I just can't figure out how to turn the data into a
stacked/clustered column chart. I can get a stacked chart, but it
own't be clustered (by year). I can cluster by year, but then I can't
stack the age groups on top of each other.

Or maybe I'm missing something.


Thanks,
Rob

 

[Nick 'The database Guy']

I think that you want to be looking at the grouping in your query,
rather than the chart.

Good luck,