Edit charts and tables

When you search your data or edit an existing Answer, Explore automatically creates the type of chart or table that it thinks makes the most sense for the data. But you can edit it to fit your needs. The following examples show some of the available options.

Important: Save your changes before closing the editor. Select More > Save at the top of the visualization.
Important: If you're viewing an existing answer, a lock next to the title means you only have View access. You can still edit the search, but you can't save changes. Select the lock to request edit access from the owner.

General options

Title and description
Select the title and description to edit them.
Choose a chart or table
Select View chart to display the data as a chart. Or select View table to display it as a table. When you save your changes, other users see the view you chose. They do not see both the chart and table unless they have permission to open and edit the visualization.

Chart options



1. Chart type
Select Change visualization , then select from more than 20 chart types. To learn more about each type, see the ThoughtSpot documentation: Chart types
2. Hide legend items
Select any legend item to hide or show it in the chart. Double-click any legend item to show ONLY that item. Double-click it again to show all items.
3. Colors
In multicolored charts, select any legend item color to edit it.
4. Axis properties
Select either the x-axis or y-axis to edit the properties. For example, you can add conditional formatting and format null and missing values. Click the small arrow to the right of the x-axis name to sort it in ascending or descending order.
5. More configurations
Select Edit chart configuration for more display options. For example:
  • Add labels and gridlines.
  • Set a maximum number of data points.
  • Switch axes.
  • Choose which fields to include in the tooltip that appears when you hover over a data point.
  • Choose a sort order for attribute values.
Note: The Select an area tool zooms into the chart, but it's only visible to you. Zoomed areas are not saved in your Answer for other users.

Table options



1. Column properties
To edit column properties, hover over the column name and select the More ellipsis. For example, you can configure text wrapping, conditional formatting, and rename the column.
2. Sorting
You can sort by a column in ascending or descending order. Hover over the column name and select the More ellipsis, then select Sort.
3. Hide columns
You can hide a column from a table, while keeping it in the search. Select Edit chart configuration , then drag columns from Visible Columns to Hidden Columns. You can still use a hidden column to sort the data.

What to do next

Save your visualization to create an Answer and share it with your organization.