Configure columns for the X and Y axes

Specify which fields to show on the x-axis and y-axis of a chart. When you first run a search, some measures or attributes may not be visualized. You can add them to the other measures or attributes on the axes of a chart by dragging these columns from the not visualized section in the chart configuration panel to the correct axis.

You can only add attributes to the x-axis, and measures to the y-axis. If you cannot add a column to a specific axis, the option to do so does not appear to you when you attempt to drag and drop the column. Attributes appear blue in the search bar and in the Customize menu, while measures appear green.

The x- and y-axes on a bar chart work in a different way than other charts. In bar charts, attributes are on the y-axis, and measures are on the x-axis.

You can also drop attributes and measures to the not visualized section. This removes them from the visualization, but not from your search. Move items to the not visualized section either by dragging and dropping them, or by selecting the x that appears when you hover over an attribute or measure in the Customize menu. You can use this functionality to perform a hidden sort, by moving the measure column you want to sort by to the 'Not Visualized' section. Note that you cannot perform hidden sorts using attributes.

You can also drag and drop attributes into the slice with color section, which appears for certain chart types, such as column or bar charts, if you have more than one attribute in a search. Note that you can only use an attribute to slice with color. Slicing with color enables you to separate data already sorted by an attribute into subcategories, based on another attribute in your search. In the following example, we sliced sales for each department by store region.

Slice with color

To drag and drop columns to the correct axis, or to the slice with color section, follow these steps:

  1. Select the chart configuration icon chart configuration icon image on the upper right.

  2. Drag and drop a measure or attribute from the Not visualized section to the correct axis, or from an axis to the Not visualized section. Or, drag an attribute to the Slice with color section.

    Configure x and y axis

In some cases, the y-axis labels appear on either side of the chart (left and right) instead of stacked on the same side, depending on the parameters of the analysis. Refer to Change the position of the axis and Change the grouping.

For a list of chart types to which this applies, see Charts with multiple measures on the y-axis.

Was this page helpful?