Lollipop Charts

A Lollipop Chart is very similar to a bar chart, but typically uses thinner lines ending in a circle. This allows for some stylistic interest as well as a place to show values or other labels. Here, for example, is a Lollipop Chart for Sales of Categories in the Technology department:

Features and techniques used to create this chart include the following:

  • A synchronized dual axis for SUM(Sales) with one mark type set to Bar and the other mark type set to Circle.
  • The size of the bars and circles have been adjusted (click Size on the Marks card). The bars have been set to be very thin, while the circles are large enough to accommodate the label.
  • Sales have been added to the label of the circle and formatted using a custom currency.
  • Axes have been hidden (right-click and uncheck Show Header).
  • Grid lines have been hidden (use the formatting options opened from the menu Format | Lines).

You might experiment with some variations, such as the following:

  • Swapping Rows and Columns to flip the orientation
  • Sorting Categories
  • Using color or highlighting to call out certain values
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.191.194.123