Column Chart-Line Chart

1)  The Combination Chart can display more than one types of charts at the same time, and has four types: Column-Line Chart, Column-Area Chart, Stack Column-Line Chart and Custom. The Custom Combination Chart can freely combine 15 charts such as Column Chart, Line Chart, Area Chart, Pie Chart and Gauge.

2) The Combination Chart is applicable to scenarios where multiple types of data in more than one dataset need to be compared simultaneously, showing the differences between different data, and  comparing the proportion of each category.

3) A Combination Chart greatly increases the freedom in chart design, so you can freely choose a suitable combination of charts according to your needs, and combine the advantages of all these charts.

4) Please read: Chart Data, Chart Style, Chart Special Effects

1. Prepare Data

1) Create new Normal Report and new datasets ds1 and ds2.

2) Use the default data to connect FRDemoEN.

3) Input the following data query statement ds1:

SELECT Product_name, Order_quantity, Re_order_quantity FROM Product
WHERE CategoryID=1

4) Input the following data query statement ds2:

SELECT Product_name, Inventory_quantity FROM Product
WHERE CategoryID=1

2. Insert chart

1) Taking the Custom-Line Chart as an example, this article introduces steps to create a Combination Chart which can be inserted as follows:

• Select [Combination Chart] on the left pane of [Chart Type] interface.

• Select the [Custom] on the right pane.

• Click [OK] to complete the insertion of [Custom].

2) Double click the chart to enter the [Type] setting interface, and check the Type that you want to display. Here the Bar Chart and Line Chart are checked by default.

Note: The order in which they are checked determines the order in which the layers will be overlaid. The later the chart is checked, the upper the layer is. 

3. Bind Data

1) Bind the data of the Bar Chart:  Select the Combination Chart, and click [Cell Element] on the right-hand pane. Click [Data]-[Column] to select [Column Chart].

• Select [Dataset data] in [Data source], [ds1] in [Dataset], and [Product_name] in [Category].

• Select the default [Enable Field Name] for the [Series Name From]. Click  to add [Field Name] including Order_quantity and Re_order_quantity. Set [Series Value] as Order quantity and Reorder quantity respectively.

2) Bind the data of Line ChartClick [Cell Element] on the right-hand pane. Click [Data]-[Line] to select [Line Chart].

• Select [Dataset data] in [Data source], [ds2] in [Dataset], and [Product_name] in [Category].

• Select the default [Enable Field Name] for the [Series Name From]. Click  to add [Field Name] including Inventory_quantity. Set [Series Value] as Inventory quantity.

4. Set style

1) Change the chart title: Double-click the Combination Chart and select [Style]>[Title] to change the settings.

• Modify the title of the Combination Chart by setting [Text] to:  Colum-Line Chart.

2) Create a coordinate axis: Add a Y axis so that the Column Chart and Line Chart can use different axes.

• Click [Style].

• Select [Axis].

• Click  on the rightmost to insert a new Y axis. You can set the newly inserted coordinate axis.

3) Custom coordinate axis for Column Chart: Set the coordinate axis to be used for the Column Chart.

• Click [Style].

• Select [Series].

• Select [Column] and click  to add a new stack and axis condition to the Column Chart.

• Set the stack and axis condition as shown below.

4) Custom coordinate axis for Line Chart: Set the coordinate axis to be used for the Line Chart.

• Click [Style].

• Select [Series].

• Select [Line] and click  to add a new stack and axis condition to the Line Chart.

• Set the stack and axis condition as shown below.

5. Preview Effect

Below is an example of a Combination Chart whose Style has been set. The Column Chart uses the first Y axis (left to right), and the Line Chart uses the other Y axis.