Combo Chart
In this article, we will explain how to create and customize a Combo or Combination chart. So let's get started!
A combo chart, also known as a combination chart, is a chart that combines a line chart and a column chart on the same plot. Combo charts can display multiple data series or compare different types of data on the same chart.
Here is an example of a combo line and column chart with sample data:
In this example, a combo line and column chart are used to show the trend in sales and profit over a period of time (e.g., months or years). The x-axis represents time, and the y-axis represents the dollar amount for each data series. The chart includes two data series: sales (represented by a line chart) and profit (represented by a column chart).
Sample data:
| Time Period | Sales ($) | Profit ($) |
|---|---|---|
Jan 2020 | 100,000 | 10,000 |
Feb 2020 | 110,000 | 8,000 |
Mar 2020 | 120,000 | 12,000 |
Apr 2020 | 130,000 | 14,000 |
May 2020 | 140,000 | 8,000 |
Jun 2020 | 150,000 | 6,000 |
How-to build a combo chart?
Navigate to Add New Chart screen
Select data source
Select "Combo Chart" type from gallery
Combo chart configuration:
1) The configuration shown illustrates how to map the time period on the x axis and the profit and sales on the y axis in order to generate the line chart.
2) To change a data series to a column or line chart, follow these steps:
Click on the "Customize" tab
Go to "Series" and select the desired data series from the drop-down menu
Set the type to "Line" or "Column"
Combo line and column charts are often used to compare different types of data or to display multiple data series on the same chart. They can be particularly useful when one data series is continuous (e.g. a line chart) and the other is discrete (e.g. a column chart).
Some useful tips for creating combo line and column charts include:
Clearly label the x-axis and y-axis, including units of measurement if applicable
Use a consistent scale for the y-axis to accurately compare data points
Consider using a legend to label multiple data series on the same chart
Use a clear and concise title to describe the data being displayed
Avoid cluttering the chart with too much data or unnecessary elements
Use a meaningful and appropriate time scale for the x-axis (e.g. days, weeks, months, years)
Choose appropriate chart types for each data series (e.g. line chart for continuous data, column chart for discrete data)
Combo chart customization options:
Infinity offers many customization options for your chart. To access these options, click on the customize tab in the chart builder screen. This will display a list of customization options.
Here is a list of notable customization options for the line chart.
| Feature | Description |
|---|---|
Aggregation | To create an aggregation, click on the data series chip in the data mapping section and choose the desired aggregation. There are various aggregation options available based on the data type. |
Renaming the Data Series | To rename a data series, click on the data series chip in the data mapping section. A pop-up will appear, allowing you to change the name and any aggregation options. |
Dual Axes or Right hand Axes | To enable dual axes, follow these steps:
|
Titles | To change the titles, follow these steps:
|
Chart Background | To change the chart background, follow these steps:
|
Padding and Zoom | To change the padding and zoom, follow these steps:
|
Legend | To customize the legend, follow these steps:
|
Axes | To customize the axes, follow these steps:
|
Gridlines | To change the grid lines, follow these steps:
|
Chart Area | To configure the opacity of the color in the chart background area:
|
Last updated
