Table Chart
In this article, we will explain how to create and customize a Annotation chart. So let's get started!
Last updated
In this article, we will explain how to create and customize a Annotation chart. So let's get started!
Last updated
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:
Navigate to Add New Chart screen
Select data source
Select "Table Chart" type from gallery
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.
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.
There are a few useful tips to keep in mind when using table charts:
Make sure to clearly label the chart and include a descriptive title.
Use a clear and readable font for the labels and data values to make it easier for readers to understand the chart.
Use appropriate formatting and alignment to make the data easy to read and understand.
Consider using filters or sorting options to help users focus on specific data points or trends.
| Country | Population (millions) | GDP per capita ($) |
|---|---|---|
| Feature | Description |
|---|---|
United States
330
62,641
China
1,439
10,261
India
1,380
2,059
Indonesia
273
4,295
Brazil
212
9,731
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:
Modify the font of the header text by changing its color, size, family, and style (bold or italic).
Change the background color of the header text.
Convert the header text to all uppercase.
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:
Modify the font of the data in the table by changing its color, size, family, and style (bold or italic).
Set the background color for odd and even rows separately.
Set the opacity for odd and even rows separately.
Adjust the density of the rows to be small, medium, or large.
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:
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:
Go to the "Customization" section of the table.
Under "Series," select the series or column that you want to format.
Click "Add Rule" to set up the condition and the conditional formatting.
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."
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:
Go to the "Customization" section of the table.
Under "Series," select the series or column that you want to format.
In the "Show As" option, select "Bar" or "Bar with Data" to display the data as inline bars or bars with data labels, respectively.
The selected display option will be applied to the selected series or column.
Aggregations: Automatically calculate aggregations, such as sum, average, min, max, or others, for each column.
The formatting will be applied to all cells that meet the specified condition.
