How to add vertical lines to a bubble chart

Published: 27 Jun 2023
Last Modified Date: 28 Jun 2023

Question

How to add vertical lines to a bubble chart?

Current Behavior
User-added image

Desired Behavior
User-added image

Environment

Tableau Desktop

Answer

This can be achieved by using a dual axis with a bar chart.
Please follow along with the attached sample workbook to the right of this text in the Attachments section.

STEP 1

Create a bubble chart.

1. Connect to the Sample Superstore data from Tableau Desktop.
2. Right-click and drag Order Date to Columns, then select "MY (Order Date)".
User-added image

3. Drag Sales to Rows.
4. Change the mark type to Shape.
User-added image

STEP 2

Add the vertical lines.

5. Double-click on Rows next to Sales and enter '1'.
User-added image

6. Open the Marks card for SUM(1) and change the mark type to Bar.
User-added image

7. Right-click on the bar chart axis and select Edit Axis...
User-added image

8. Set the axis as shown below.
User-added image

9. Click on Size on Marks card and set size to the minimum.
User-added image

10. Right-click on SUM(1) on Rows and select Dual Axis.
11. Click on the drop-down arrow on the color legend and select Edit Colors... to set your desired colors.
User-added image