top of page
hand-businesswoman-touching-hand-artificial-intelligence-meaning-technology-connection-go-

Create a Enclosed Dot Plot


Image by Author


In this tip, we will see how to create an enclosed dot plot, which is essentially a dot plot that is enclosed by a line. It's very similar to a barbell chart except the line connecting the dots surrounds to dots. We are taking the Superstore dataset for plotting our chart.


Step 1:

Connect to Superstore dataset through Data Source.



Step 2:

Drag Sub-Category on to row and Sum(Sales) on the Columns. Then convert them to Dimensions and then drag Region on Colors


Step 3:

Perform below series of steps to create dual charts for the sum(Sales)

  • convert chart type from automatic to circle for the Sum(sales) measure

  • make a duplicate value Sum (sales) onto rows

  • convert chart type from automatic to line for the Sum(sales)(2) measure

  • lastly, for Sum (sales)(2) drag Region onto the Path



Step 4:


Synchronize 2 charts using dual axis as below

  • right click on Sum(sales) to make Dual Axis to merge one chart

  • right click on bottom axis of Sum(sales) to synchronize the axis

  • right click on bottom axis and then click on "Move marks to front"



Step 5:


Show all values including zero by right clicking on bottom axis and then click on Edit Axis to uncheck include zero


Step 6:


Hide headers by right clicking on top axis and do uncheck show header



Step 7:


Perform below formatting steps to show as enclosed dot plot chart

  • go back to Marks card, go to Sum (sales) (2) and then increase the size of line that surrounds the circle

  • change the orientation to Fit Height and adjust the view for best fit.

Step 8:

This is how the enclosed data plot chart look a like.




Happy to share my first blog :)

Happy Analyzing.....

85 views1 comment

Recent Posts

See All

1 Comment

Rated 0 out of 5 stars.
No ratings yet

Add a rating
Kamalika Barua
Kamalika Barua
Mar 07, 2023
Rated 5 out of 5 stars.

Excellent article

Like
bottom of page