Get a Complete Picture of Your Data with Tableau’s Shared Axis Bars

In Tableau, you can use the “Share Axis” option to create charts that share a common axis, allowing you to compare the values of different measures or dimensions more easily. It can be used when you want to compare multiple measures or dimensions that have different scales, as it allows you to see the relative differences between the measures or dimensions more clearly.

These diagrams are used to show how two variables relate to one another. These graphs are particularly helpful for showing the link between two or more metrics of the same or different scale.

You can contrast data series measured in various units or using various comparison scales using tableau dual axis charts. For instance. Using the example below, we compare the sales to profit ratio. Profit Ratio is expressed in percentage, whilst Sales Unit is expressed in dollars.

Shared Axis Charts: In Tableau, a shared axis chart divides one axis across several metrics. When the measurements’ ranges of values are similar, this chart, which only uses one mark and one scale, can be utilised.

Simply drag the second measure from the rows or columns section and drop it on the Y-axis of the first chart to create a shared axis chart.

Simply right-click on the bottom chart’s y-axis and choose “Dual Axis” to create a dual axis chart.

To create charts that share an axis in Tableau, follow these steps:

1. Connect to a data source and drag the fields that you want to use to create the charts to the Columns and Rows shelves.
2. From the Show Me menu, select the chart type that you want to use for the first chart. This will create a basic chart based on the fields that you selected.
3. To add a second chart that shares the same axis as the first chart, drag the field that you want to use for the second chart to the Columns or Rows shelf, depending on the chart type that you are using.
4. Right-click on the axis for the second chart and select “Synchronize Axis”. This will link the two axes together, allowing the charts to share the same scale.
5. Customize the appearance of the charts as needed. You can change the colors, labels, and other formatting options for the charts using the formatting options in the top menu.

Sharing an axis between charts can be a useful way to compare the values of different measures or dimensions in Tableau. It allows you to see the relative differences between the measures or dimensions more clearly, and can help you communicate insights more effectively.