Create series Bar chart | jfreechart | dashboard

The basic requirement   is that the SQL query should return three columns

 

for e.g.

select     Format(date,'YYMM') & ' - '& Format(date,'MMM') as       Month , switch(class is null,'Unknown Class',class is not null,class) as class_type, sum(amount) as Expense

from

[qb_data$]

where "Account Type" = 'Expense'

and date between         #10/1/2007# and     #05/23/2008#

and class   like '%'

group by Format(date,'YYMM') & ' - '& Format(date,'MMM'), switch(class is null,'Unknown Class',class is not null,class)

order by 1 asc

 

In the above SQL, the three columns are Month, Class_type and Expense.

 

This requirement is same as creating a stacked bar chart, except the bar chart type = 'Bar' in this case