Search
K
Comment on page

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?

1. 1.
Navigate to Add New Chart screen
2. 2.
Select data source
3. 3.
4. 4.
Configure and customize the chart to create the desired visualization.

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.
Sample Line chart data mapping
2) To change a data series to a column or line chart, follow these steps:
1. 1.
Click on the "Customize" tab
2. 2.
Go to "Series" and select the desired data series from the drop-down menu
3. 3.
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:
• Click on the customization tab.
• Click on series.
• Select the series that you want to plot on the right-hand axes.
Titles
To change the titles, follow these steps:
• Click on the customization tab.
• Click on the horizontal (or) vertical axes.
• Proceed to change the titles.
• You will also have the option to modify the font attributes.
Chart Background
To change the chart background, follow these steps:
• Click on the customization tab.
• Click on the chart background.
• Proceed to selecting the desired color.
• Click on the customization tab.
• Click on the padding and zoom accordion.
• Proceed to customize the padding and zoom attributes for your chart.
Legend
To customize the legend, follow these steps:
• Click on the customization tab.
• Click on the legend accordion.
• The platform offers four legend options: top, bottom, right, or none.
• You can also configure the legend font here.
Axes
To customize the axes, follow these steps:
• Click on the customize tab.
• Select the desired axes (horizontal for X, vertical for Y, and right vertical for secondary Y).
• Proceed to changing the title, fonts, labels, order of axes, scale, or even add formatting such as \$ or %.
Gridlines
To change the grid lines, follow these steps:
• Click on the customize tab.
• Select the gridlines accordion.
• Select the orientation (i.e. vertical or horizontal).
• Update/customize the count and colors of the gridlines.
Chart Area
To configure the opacity of the color in the chart background area:
• Click the "customize" tab
• Select the "chart area" accordion
• Choose the desired opacity for the background area