Combo Chart
In this article, we will explain how to create and customize a Combo or Combination chart. So let's get started!
Last updated
In this article, we will explain how to create and customize a Combo or Combination chart. So let's get started!
Last updated
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:
Navigate to Add New Chart screen
Select data source
Select "Combo Chart" type from gallery
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)
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.
| Time Period | Sales ($) | Profit ($) |
|---|---|---|
| Feature | Description |
|---|---|
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
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.
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.
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.
Padding and Zoom
To change the padding and zoom, follow these steps:
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).
Chart Area
To configure the opacity of the color in the chart background area:
Click the "customize" tab
Select the "chart area" accordion
Select the series that you want to plot on the right-hand axes.
You will also have the option to modify the font attributes.
Update/customize the count and colors of the gridlines.
Choose the desired opacity for the background area
