Skip to main content

Tableau(Dual axis combination charts in tableau)

 

Dual axis Combination Chart:

👉  Dual axes are useful for analyzing two measures with different scales. To add a measure as a dual axis, drag the field to the right side of the view and drop it when you see a black dashed line appear. You can also right-click (control-click on Mac) the measure on the Columns or Rows shelf and select Dual Axis.

Creating a Dual axis combination charts:

👉  Combination charts are views that use multiple mark types in the same visualization. For example, you may show sum of profit as bars with a line across the bars showing sum of sales. You can also use combination charts to show multiple levels of detail in the same view.

To create a Dual axis combination chart, follow the steps below:

  1. Open Tableau Desktop and connect to the Sample - Superstore data source.

  2. Navigate to a new worksheet.

  3. From the Data pane, drag Order Date to the Columns shelf.

  4. On the Columns shelf, right-click YEAR(Order Date) and select Month.

  5. From the Data pane, drag Sales to the Rows shelf.

  6. From the Data pane, drag Profit to the Rows shelf and place it to the right of SUM(Sales).

  7. On the Rows shelf, right-click SUM(Profit) and select Dual-Axis.

    The view updates. Measure Names is added to Color on the Marks card to differentiate the lines.

  8. On the SUM(Profit) Marks card, click the Mark Type drop-down and select Bar.

  9. In the visualization, right-click the Profit axis and select Synchronize Axis.

    Output:

Comments

Popular posts from this blog

String Functions in C Language(C Language)

PHP Array Functions

Home Menu Options in Ms Word