Changing charts

You can adjust all aspects of ThoughtSpot charts: color, legends, axis, number format, and many more.

To make changes to the chart configuration, select the gear icon in the upper-right corner of the visualization.

Edit chart configuration

This opens the Edit chart panel for the chart, which contains the Customize and Settings menus. Using this menu, you can drag and drop measure and attribute chips to or from an axis. Click on any measure or attribute chip that has a more icon (>) to customize it. In the following image, Total Sales is customizable.

Edit chart configuration

You can edit some of the elements of the chart directly, by clicking on them. For example, you can change the appearance of a chart axis by clicking it and making selections in the available options.

Chart configuration options

Through the Customize menu, you can perform a number of customizations:

  1. Drag and drop measures and attributes to or from an axis

    • Set up your chart by dragging and dropping the measures and attributes in your search onto the appropriate axis.

      If you want a column to be part of your search and show up in the table view, but you do not want to include it in your chart, you can drag it to the ‘Not Visualized’ section. You can also use this functionality to perform a hidden sort, by moving the measure column you want to sort by to the ‘Not Visualized’ section.

  2. Number formatting for all data labels

    • Category (Number, Percentage, Currency)

    • Units (K, M, B)

    • Decimals

    • Independent control for each measure on the chart

  3. Axes

    • Grouping and ungrouping of axes

    • Axis renaming

    • Changing the position of an axis

    • Changing the axis minimum and maximum values

    • Changing number formatting on the axis

  4. Change position of the legend

    • When you create a visualization, you have the option to change the legend position, or hide the legend entirely. Select the chart configuration icon gear icon and select Settings. You can choose to position Legend on right, Legend on left, Legend on top, or Legend on bottom.

    • Click the Show legend toggle to hide the legend.

Through the Edit chart menu, you can perform a number of customizations:

Drag and drop measures and attributes to or from an axis

Set up your chart by dragging and dropping the measures and attributes in your search onto the appropriate axis.

If you want a column to be part of your search and show up in the table view, but you do not want to include it in your chart, you can drag it to the ‘Not Visualized’ section. You can also use this functionality to perform a hidden sort, by moving the measure column you want to sort by to the ‘Not Visualized’ section.

Number formatting for all data labels
  • Category (Number, Percentage, Currency)

  • Units (K, M, B)

  • Decimals

  • Independent control for each measure on the chart

Change axis options
  • Grouping and ungrouping of axes

  • Axis renaming

  • Changing the position of an axis

  • Changing the axis minimum and maximum values

  • Changing number formatting on the axis.

Change chart colors

Change the color chips for a column or a value. You can set custom colors for bars, lines, areas, bubbles, maps, and other chart types. You can also "slice" with color, set legends on charts, and enable conditional formatting in tables.

Results that are tables
Reorder labels on the axis or legend

When there are multiple columns on the x- or y-axis or legend of a chart, you can change their position in the chart by using the chart configuration icon.

Set the y-axis range

Manually set the y-axis range by using the chart configuration icon.

Hide and show values

Change the visibility on the chart using the legend.

Show data labels

Configure charts to show the y-axis data values.

Show data markers

On line charts, show data markers.

Specify time bucketing

You can easily change the date bucketing on a chart or table, from weekly to month of quarter, for example.

Add regression lines

You can add a regression line to your chart.

Display gridlines

Add X and Y gridlines to your chart.

Disable automatic selection of chart type

Turn off the 'automatically select my chart' option if you want a specific chart type to persist throughout a search.

Zoom into a chart

You can zoom into your chart by selecting an area with your mouse.