Skip to Content
0
Former Member
Feb 18, 2009 at 09:09 PM

Bar chart query

31 Views

Hi,

I have about 100 records in a database. In each record there are 4 fields:

(1) Text field: yes/no (smoker?)

(2) Text field: (membername?)

(3) Text field: yes/no (Drink alcohol?)

(4) Date field

I have produced a report that, using parameters, asks the user for a date (start and end dates).

When the dates are given, a bar-chart is produced which shows:

1. (on the vertical axis) The amount of yes values in the smoker field.

2. (on the vertical axis) The different member names.

On the bars that are displayed, I want to get them so that the bars are split in 2 by different colours. The different colours representing the amount of 'drink alcohol' text field that are yes or no.

How can I get it to do this?

(I hope my drawing below helps)

Thanks

J

! ____

! ___ ! !

! ! ! ___ ! !

yes ! ! ! ! !

! ! ! ! ! ! !

! ! !

!_!__ !____!___! !___!__________________________

john peter mary ...............etc