Often you may find that you have long titles or labels in your data that you want to preserve and not reformat to find a small space in your table chart. In cases where you are displaying long text in a table chart in Chartio, you have a few options on how to handle the text.
You can enable text wrap on your table chart through the chart settings as shown below. Depending on the various lengths of the text in your columns, this may result in a bit of an inconsistent presentation of your data as some labels will span multiple rows, others may only use one row.
A second option is to adjust the column width for table charts by navigating to the columns tab under chart settings. You may add a new rule to a column and adjust its width.
One thing to note when you use the column width formatting in the settings is that Chartio will only display the first 100% of your table. If the total sum of all the column percentages exceeds 100, it may be that not all columns are displayed on your chart.
To fix this problem, you will need to toggle through each of your custom column formatting rules and adjust the percentages to ensure that the total does not exceed 100%.
One last option for long text is that you can enable clicking the text column to display the full text using drilldowns by following the steps outlined below.
In this example, we have a Table chart with a truncated text column. We want to be able to click the text column to display the full text.
1. Add a new Hidden Variable. Be sure to check the Can Drilldown checkbox.
2. Open the Chart Settings for your Table chart, and switch to the Drilldown tab. Select the current dashboard, and map your text column to the new Hidden Variable.
3. Add a Text element to your dashboard by clicking on the Add Text option from the dashboard side menu. In the Text box, enter the name of your hidden variable between curly braces. Select your preferred font style and click Done.
You can now click a row in your table, and the Text element will be populated with the content of the text field.
Note: You may need to refresh your browser after the creation of the Text element in order for the changes to take effect.