Stacked Bar Chart Tutorial

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.
• 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 “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.