Peltier Tech Blog

Excel Chart Add-Ins | Training | Custom Solutions | Charts and Tutorials | PTS Blog

 

Main menu:

 
Peltier Tech
Chart Add-Ins

Peltier Tech Waterfall Chart Utility
Peltier Tech Cluster-Stack Chart Utility
Peltier Tech Box and Whisker Chart Utility
Peltier Tech Marimekko Chart Utility
Peltier Tech Dot Plot Utility
Peltier Tech Cascade Chart Utility

 
Excel Dashboards

Subscribe

Site search

Subscribe

Site search


Recent Posts

Recently Commented

Popular Posts

Archive


 

Categories


 

Privacy Policy

Creative Commons License
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

Dating Site Photo Effectiveness

by Jon Peltier
Tuesday, February 2nd, 2010
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

Kaiser of JunkCharts has posted twice in a couple days about some charts that compare the effectiveness of different profile photo topics, in terms of attracting a potential date. The article that led to the controversy is The 4 Big Myths of Profile Pictures on a site called OK Cupid. Kaiser posted first in Light entertainment, where his attitude was “who cares, really?”, but after receiving serious feedback, he revisited the charts in From light to heavy. I should note that Kaiser himself is quite a good Chart Buster.

There are a number of strange and wonderful charts on the dating site, but the one that led to this specific discussion is shown here.

Original Photo Effectiveness

The major controversy it that the horizontal X axis is not located at zero on the Y axis, but at the average effectiveness of 27%. A second issue is that vertical bars pretty much force category labels with hard-to-read orientations. If these are really a problem, then a horizontal bar chart with the bars starting at zero solves it, as Kaiser demonstrates.

If you are interested in relative effectiveness of each photo category, then the zero axis origin may not be so important. Also, the resolution of this chart is better than if the bars had to start at zero.

Kaiser's Take on Photo Effectiveness

This is an improvement in terms of legibility of labels and judging the absolute values of the bars. Perhaps a dot plot is equally effective?

Photo Effectiveness Dot Plot

Unlike a bar chart, starting the value axis at a value greater than zero poses no cognitive issues. We can then expand the scale, to gain back the resolution of the original chart.

Photo Effectiveness Dot Plot

What do you think of these alternatives?

Related Posts:

Bookmark and share this entry:
  • Twitter
  • Digg
  • Facebook
  • LinkedIn
  • del.icio.us
  • Technorati
  • StumbleUpon
  • Google Bookmarks
  • Reddit
  • MySpace
  • Slashdot
  • Yahoo! Buzz
  • Tumblr

Learn how to create Excel dashboards.

Comments


Comment from ikkeman
Time: Tuesday, February 2, 2010, 3:03 am

I do think the dot plot runs the risk of loosing the relation between the data label and it’s data point.
It’s already in play in the chart above, but as the list of data labels expands, it becomes harder to determine which point correlates to which label.

The Gridlines help, but I think the barchart offers better readability.
Maybe a thin-bar chart with big dots at the end of each bar?


Comment from derek
Time: Tuesday, February 2, 2010, 5:25 am

If you need the labels to be associated with the dots, you can label the dots directly, although I prefer then lined up on the left.


Comment from Stružák
Time: Tuesday, February 2, 2010, 5:39 am

If there is one thing I really admire on the dot plot charts, it must be the fact, that it can be easilly made and read using just one or two colours. Well done!


Comment from Thom Mitchell
Time: Tuesday, February 2, 2010, 9:02 am

You may be a victim of your own effectiveness or powers of persuasion: you have made me a believer in bar charts with a zero base. I prefer the ability to identify small *relative* differences, rather than spreading out the data points of a dot plot to fit a horizontal scale of smallest [numerical] width, i.e., the range of the values. Color me a bar chart fan!


Comment from Gary
Time: Tuesday, February 2, 2010, 9:33 am

Actually the original (maybe turned 90 degrees) works great if you just relabel the axis to “Deviation from Average…” That way the zero-based bars are irrelevant. I like this more than the dot plot, actually, since there’s only one series. Maybe use data labels to indicate the actual effectiveness percentage values. I don’t like double-axis-ing it so much.


Comment from Jon Peltier
Time: Tuesday, February 2, 2010, 10:10 am

Ikkeman -

The gridlines in the dot plot can be made more pronounced to help with identification, or the labels can be placed next to the points per Derek’s suggestion.

If you decide to use bars, just use bars, but don’t clutter them with markers as well.

If clearly marked, bars showing Deviation from Average also work. There are many ways to skin this cat, and there are multiple ways to do so effectively.

Gary -

I don’t like Secondary Axes in Charts much myself, but this is one example of Secondary Axes that Work.


Comment from Jeff Weir
Time: Tuesday, February 2, 2010, 3:07 pm

Jon…you’re going really dotty on us. Do a Google image search on Yayoi Kusama…she’s got an exibition here in Wellington New Zealand that I’m sure you would approve of


Comment from Jon Peltier
Time: Tuesday, February 2, 2010, 6:14 pm

Here is what Jeff is talking about.


Trackback from uberVU – social comments
Time: Friday, February 5, 2010, 2:14 am

Social comments and analytics for this post…

This post was mentioned on Twitter by Jon_Peltier: New on the PTS Blog: http://zz.gd/e7aba7 Dating Site Photo Effectiveness…


Comment from Jeff Weir
Time: Friday, February 26, 2010, 10:53 pm

I love the categories in these graphs. They really beg the question as to how effective a photo would be of you doing something interesting with a friendly animal in bed while on holiday.

Write a comment

I welcome comments from my readers. If you have an opinion on this post, if you have a question or if there is anything to add, I want to hear from you. Whether you agree or disagree, please join the discussion.

If you want to include an image in your comment, post it on your own site or on one of the many free image sharing sites, and include a link in your comment. I'll download your image and insert the necessary html to display the image inline.

Read the PTS Blog Comment Policy.





Subscribe without commenting

Peltier Tech Waterfall Chart Utility Peltier Tech Cluster-Stack Chart Utility Peltier Tech Box and Whisker Chart Utility Peltier Tech Marimekko Chart Utility Peltier Tech Dot Plot Utility Peltier Tech Cascade Chart Utility

Create Excel dashboards quickly with Plug-N-Play reports.