Change axis options

To change the axis aggregation, click the Aggregate option in the axis menu, and select an alternative from the list of options.

Depending on the type of data type and other settings, the aggregation options include Total, Avg, Min, Max, Total Count, Unique Count, Std Deviation, and Variance.

To manage the filters applied to the axis (in this example, Total Sales), follow these steps:

Here, you can see differences between the original chart and the one with the filter applied: Three (3) of the departments had sales less than $1,000,000, and they don’t appear on the newer chart.

To remove a filter from the chart, select the x icon on the filter tile.

You can use conditional formatting to show charts with a target value or range drawn as a line in the chart, and the legend colors determined by where values fall relative to the target.

To apply conditional formatting to a chart (in this example, Total Revenue by Supplier Country), follow these steps:

Here, you can see a chart that highlights elements with conditional formatting on some elements. You can also see how the same chart appears with a background chart band.

To change the sorting of a measure on an axis, select the Sort option in the axis menu, and choose an alternative from the list of options: Ascending or Descending.

Here, you can compare the original chart that was not sorted on the Total Sales axis with the chart that uses descending sort.

It is generally easier to interpret a chart if axes that use the same units of measurement or scale appear on the same side of the chart. In our example, we can best visualize Item Cost and Item Price on the same side of chart.

To change the position of an axis, click the Position option in the axis menu, and then select an alternative from the list of options: Left or Right.

Here, we move the Item Price axis from the right side of the chart to the left side.

You can compare the original chart with the one where the Total Sales axis is on the right, while Item Cost and Item Price both appear on the left.

When two axes use the same unit of measurement and a similar scale, we can group them together.

To change the grouping on an axis, select the Group option in the axis menu, and choose an alternative from the list of options, which are the measures on the other axes.

Here, we change the Item Price axis by grouping it with Item Cost.

Compare the original chart with one that groups Item Price and Item Cost as Item Price & Item Cost. The chart looks cleaner, and clearly communicates the distinct information for each of the two measures.

Notice that the Customize menu shows a linkage between the two grouped axes.

You can always rename an axis for clarity, brevity, format, and so on.

In our example, it makes sense to rename the axis created from grouping as Item Price & Item Cost to something shorter, like Item Price and Cost.

To rename an axis, select the Rename option in the axis menu, type the new name, and either click out or select Enter/Return on your keyboard.

When you choose to edit the axis, you get the comprehensive view of everything that can be changed on the axis: you can Configure the axis name, position (left or right), and the minimum and maximum values, and you can Format the category of the column, its units, and the representation of negative values.

To edit this axis (in this example, Item Price), follow these steps:

Removing the axis removes the data from the display, but not from the Answer entirely. Instead, the column that the axis represents appears in the Not visualized section of the Customize menu.

To remove an axis (in this example, Item Price), follow these steps: