R
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?
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?