Table Chart

In this article, we will explain how to create and customize a Annotation chart. So let's get started!

A table chart is a type of chart that displays data in a tabular format, with rows and columns. It is similar to a spreadsheet, and it allows users to view and analyze data in a structured way.

Here is an example of a table chart using real-world data:

This table chart shows data on the population and GDP per capita of five different countries. The columns represent the country, population, and GDP per capita, and the rows represent the individual countries.

Sample data:

CountryPopulation (millions)GDP per capita ($)

United States

330

62,641

China

1,439

10,261

India

1,380

2,059

Indonesia

273

4,295

Brazil

212

9,731

How-to build a line chart?

  1. Navigate to Add New Chart screen

  2. Configure and customize the chart to create the desired visualization.

Table chart configuration:

The configuration shown illustrates how to map the time period on the x axis and the profit and sales on the y axis to generate the line chart.

Table chart customization options

Infinity offers many customization options for your table 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.

FeatureDescription

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.

Table Header

There are several options available for customizing the table header:

  1. Modify the font of the header text by changing its color, size, family, and style (bold or italic).

  2. Change the background color of the header text.

  3. Convert the header text to all uppercase.

  4. Make the header fixed so that it does not move when you scroll.

Table Body

Infinity offers the following options for customizing the table body/content:

  1. Modify the font of the data in the table by changing its color, size, family, and style (bold or italic).

  2. Set the background color for odd and even rows separately.

  3. Set the opacity for odd and even rows separately.

  4. Adjust the density of the rows to be small, medium, or large.

  5. Fix the window or frame for scrolling by indicating the row or column number in the "Fixed Rows" or "Fixed Column" options. You can also change the background color of the fixed cells.

Table Footer

There are several options available for customizing the table footer:

  1. Pagination: Enable paginated tables and specify the number of rows per page.

Conditional Formatting

Here are the instructions for applying conditional formatting to a column in a table:

  1. Go to the "Customization" section of the table.

  2. Under "Series," select the series or column that you want to format.

  3. Click "Add Rule" to set up the condition and the conditional formatting.

  4. Specify the condition that will trigger the formatting. For example, if you want to format all cells whose value is greater than 17795 to green, you would set the condition to be "value > 17795."

  5. Choose the desired formatting options, such as the font color or background color.

Show as bar or bar with numbers

Here are the instructions for displaying data as inline bars or bars with data labels in a table:

  1. Go to the "Customization" section of the table.

  2. Under "Series," select the series or column that you want to format.

  3. In the "Show As" option, select "Bar" or "Bar with Data" to display the data as inline bars or bars with data labels, respectively.

  4. The selected display option will be applied to the selected series or column.

There are a few useful tips to keep in mind when using table charts:

  1. Make sure to clearly label the chart and include a descriptive title.

  2. Use a clear and readable font for the labels and data values to make it easier for readers to understand the chart.

  3. Use appropriate formatting and alignment to make the data easy to read and understand.

  4. Consider using filters or sorting options to help users focus on specific data points or trends.

Last updated