It might not be so obvious how to create a stacked bar chart with DBxtra.

So; here is a simple example.

Let’s take a look of the underlying query.

We have built a simple Sum query for customer sales by customer and month.

We added a top 5 to the query.

Let’s open the DBxtra Visual Report Designer.

Click on "Advanced Chart Wizard".

Select "Bar Stacked" as chart type.

Select the "Data" tab and choose "Auto-created Series".

On "Series Properties" select Series "Data.Customer".

On "Argument Properties" select Argument "Data.YY-MMMM".

On Value "Value Properties" select Value 1 "Data Invoice Total".

Adjust all other Chart formatting to your likings.

Save the Report.

Let’s take a look at the finished Report.

See also: Chart