hi,

im wondering if it is possible to combine a tacked bar chart with a clustered bar chart?

i have a clustered bar chart that has 2 vertical bars for each customer on the x axis. what i want to do is to have one of these two bars stacked.

is this possible to do and how would i do it?

thanks

J

hi,

on the x axis i have 3 customer names : bill,john,mary
on the y axis, i just have the usual numbers on a bar chart.

each client has 2 vertical bars. so bill has 2 vertical bars, mary has 2 vertical bars, john has 2 vertical bars. one bar represents a 'yes' value in a particular field in a database. the other bar represents a 'no' value.

in the chart expert, in the 'show value(s)' section i have 2 formulas, formula1 and formula2.

formula1 looks like : if ({dbfield} = 'yes') then 1 else 0
formula2 looks like : if ({dbfield}='no') then 1 else 0

in the chart expert, in the 'show value(s)' section, these two formulas are set to: 'sum of @formula1' and 'sum of @formula2'

in the 'on change of' section in the chart expert, i have the customer field which contains the customer names: john,mary,bill.

what i want is for one of the vertical bars of bill, mary and john to be stacked

(i.e, the bar is subdivided - as i want to add in more code that creates subdivisions on the bars based on other fields in the database)

and the other vertical bar of bill,mary,and john to just contain a single blue segment which corresponds to formula1 which was if{dbfield}='yes' then 1 else 0.


I know it may be hard to understand, so any suggestions on this are really really appreciated.
thanks.

j

Hi