Disclaimer

All of the topics discussed here in this blog comes from my real life encounters. They serve as references for future research. All of the data, contents and information presented in my entries have been altered and edited to protect the confidentiality and privacy of the clients.

Thursday, February 12, 2015

Tableau Visualization -- How to build lollipop Chart

Lollipop chart is a fancy and cute chart that has become pretty popular. It is named such way because the shape of the graph consist of a bar attached to a circle, forming a shape of Lollipop. This chart can be useful to provide visualization for your measure numbers in terms of 'how long' it occupies the horizontal axis and the precious location of the measure numbers on the horizontal axis as a dot. The length of the bar is determined by the size of the measure number and the location of the dot on the axis is also determined by the same measure number. Lets take a look at this graph that I start with:


Here, I have sales from the measure which I put on the column section along with Region as the dimension. In the row I have Product, another dimension.

Now, right-click on either 'sales' field and check 'Dual-Axis':


Now chart transformed:


Notice on the left side where i highlighted, there are 2 'sales' under marks windows. Click on each of those 2 highlighted icons, it will open up marks options that you can set for the displays of each of 'sales' field.

So first one is to set the first 'sales' as bar display:


And second 'sales' as circle display



Adjust the size of each of the fields, it changes the graph into looking like a lollipop by making the size of the bar smaller and size of the circle bigger:



Now, let's create another field called profit ratio, which is calculated by taking Sales and dividing it by profit:


After that, drag and drop profit ratio into color windows:


Now we have create a Lollipop chart that gives you 2 different visualization of the sales and also displays the color divergence based on the profitability. If you move the mouse over to any point on the graph, it will display the detail numbers on the chart including regions, product, sales and profit ratios.



Thanks, until next time

2 comments:

Shalin Siriwaradhana said...

I use creately for my visualization needs.

Best essay writing service said...

Thanks for this informative post. I think it will be help for my project.Keep sharing.I will sharing this article for my friends and colleagues.

Related Posts Plugin for WordPress, Blogger...