Documentation Charts

FAQs about Charts

We try to answer all the most frequently asked questions on charts here, but if you have a fresh one, send us a note at support@chartio.com or open a chat below. We’re always looking to add more!

Add a target line to your chart using Annotations or by adding a customized column in the Pipeline.

Display the country names along with your measures when hovering over a country on your Maps by standardizing the chart rows to use full country names.

You can hyperlink a field either by using a Custom formula in the Pipeline or by creating one in SQL Mode.

The Auto chart type button underneath the chart preview in the chart editor intelligently chooses a chart type that will best fit your data.

Dynamic bar charts compare one metric to another and can be helpful with comparison visualization and the chart colors can be changed easily.

Here are our answers to some common questions we've received about the chart comments feature.

Create a Line chart with multiple lines to compare data from different years.

This help article will describe why your dates or datetimes are converted over to text data type and the steps you can take to prevent this from affecting your ability to filter, sort, or compare dates or timestamps.

Insert static values to the line in your Bar Line chart by assigning, for example, a forecast value for each month in the Pipeline using Case Statements.

Chartio automatically formats dates when detected. Format dates further using SQL Mode or via the Chart Settings.

Weeks are defined using the ISO week date system, however you can change the start of the week in SQL Mode or using Relative Date Variables.

Create a dual y-axis chart by selecting Dual Y-axis under the Chart Settings and setting the number of columns to be included on the right axis.

The Explore Chart Data feature allows dashboard Viewers to view the chart in the Data Explorer and then save a copy to their own dashboard to edit.

How to add a linear regression line for a Scatter Plot chart in the Chart Settings.

If your text is very long in a table chart, you can either wrap the text or make the columns wider.

Use different colored bars in your Bar chart, even if you only have two columns in your result set.

To customize the sort of a heat map, you will need to use case statements in the pipeline to apply numbers to each day, and then sort by those numbers.

When writing queries in SQL Mode, Chartio recognizes the database you are using and uses the SQL syntax relevant to that data source.

Depending on the type of chart you are creating, the table formatting differs slightly.

The best way to track marketing metrics is with several charts that visualize your KPIs, including a funnel chart for purchases or sales.

Bucket data by hour of day, using a 12-hour format with AM and PM labels. Add a Calculated Column and use a CASE statement to set this up.

You can differentiate weekends from typical business hours in your charts using a CASE statement.