Additional chart options

On charts, you can configure data labels, grid lines, regression lines, legends, values for x or y axis, and lock or unlock.

Estimated reading time: 2 minutes

Some charts have additional options under Chart Styles and Configuration Options that are covered in each chart type topic.

Show data labels

To show data labels:

While viewing your search or answer as a chart, click Edit chart styles on the right.
Select Show Data Labels.

Show data markers

To show data markers:

While viewing your search or answer as a chart, click Edit chart styles on the right.
Select Show Data Labels.

Add regression line

Note: To add a regression line, you need a search with only one attribute and one measure. Otherwise, this option will show as disabled; i.e., greyed out on the styles panel. As soon as you modify the search to contain a single measure and attribute, the regression line option will be clickable.

While viewing your answer as a chart, click Edit chart styles.
Select Show regression line.

You can show regression lines on most types of charts (bar, stacked bar, line, bubble, and so on). In the examples below, sales is the measure and department is the attribute.

Display gridlines

Charts with X and Y axis can display gridlines. To display them:

Choose Edit chart styles.
Select one or both of the gridline options.

Configure columns for X and Y axis

You can specify which fields to show on the X axis and Y axis of a chart.

Click Edit chart configuration on the right.
Click into the X or Y axis field and select the column used in the search that you want on a particular axis.

Add columns to a chart legend

You can add to or edit the legend from the chart configuration panel.

Click Edit chart configuration on the right.
Click into the legend field to add one or more columns used in the search.

Your changes are saved automatically.
View the updated chart.

Lock the chart

You can use the lock icon to prevent ThoughtSpot from recommending other chart options or configurations. For example, you want a line chart, you can lock that display and stop TS from recommending an alternative visualization such as a funnel/pie/column and so forth. A lock applies for all subsequent answers that have the same column set.

Change chart colors