How to create a double lollipop chart

User Friendly

Visually great charts are always welcome in my inbox, so when a friend forwarded a link to me showing a tutorial on how to create a double lollipop chart, I was intrigued.  A double lollipop chart (not to confused with a cherry chart – although it looks very similar) is used to compare target vs actual performance – it’s another way of comparing one line against another.

lollipop chart WSJ

The picture above is from the post I was sent, which had a great tutorial created by SteveEqualsTrue from exceldashboardtemplates.com and a download which recreated the chart (above) seen in the Wall Street Journal.  Since I didn’t want to recreate the WSJ chart and actually wanted the chart to have conditional formatting, I created my own version.

cool chart

You can download the sample chart here.

 Step 1: Set up your data

To begin with you should have a data table with one column showing the actual…

View original post 747 more words

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s