Time for action – creating a bar chart

We will add a bar chart to our report to display information about the movies rented. Then we will configure the type of chart we want to visualize, its data source, and other characteristics. We will create a chart to display an analysis of the total number of movies rented by rating.

1. Add a Chart () object to the Report Header section under the pie chart.

2. Double-click on this new chart to start configuring it. In the upper part, choose the bar chart type:

   

3. In the right-hand part, configure the data source as follows:

   • category-column = rating (the item to be represented by the bars)

   • value-columns = [sum_amount] (the value under analysis)

   • series-by-field = [rating]

   If we do not specify the series-by-field value, the chart will show us all the bars in the same color and by default place them in Series 1. By establishing the rating value, we make each column independent from the others, and as such, each will have a different color.

4. In the left-hand part...