(Axis values)

In column selector menus, you can encounter different (Axis values) options, for example, (Value axis values), (Color by values), and (X values). Such a non-column option represents the resulting values on the axis in question. It is especially useful for referring to axes with multiple columns.

Which options are available in a column selector depends on the visualization type and what is selected on the visualization axes. If there are several axis values options, they will be displayed by clicking the (Axis values) arrow as shown above. If only one option exists, it will be available directly.

Note: In a waterfall chart, (Value axis values) is the default selection on the color by axis.

Example

The bar chart shows the sums of sales at three different departments in a store. The data is retrieved from three columns, that is, more than one column is selected on the value axis.

By selecting (Value axis values) on the Color by axis, all bar values on the value axis become part of the coloring scale as shown below. This means you can use a single gradient scale when coloring the bars, even though they represent values from multiple columns.

Note: If you change what is selected on the value axis above, the coloring automatically updates to the new selection. This is because of the (Value axis values) selection on the color axis.