A line diagram offers an alternative to a multi-row bar chart. You can read off the values faster here.

 

Figure 6.14: Multi-row line chart

Proceed as follows in the Sample Application:

 

1.  As the data source, select the "Customers > Orders > Order_Details" table.

2.  Choose Line/Symbol > Multi-Row as the diagram type.

3.  First specify the coordinate value for the category axis. Select the "Orders.OrderDate" field via the formula wizard.

4.  Select the property "Coordinate Label > Format" and select "%q/%y" in the Date-section (user-defined).

5.  Now specify the coordinate value for the series axis. Select the "CategoryName" field via the formula wizard.

6.  Specify the coordinate values for the value axis and calculate the turnover with the "Sum(Order_Details.Quantity * Order_Details.UnitPrice)" formula.