Peltier Tech Blog

Excel Charting Utilities | Custom Solutions | Training | Charts and Tutorials | PTS Blog

 

Main menu:

 
Peltier Tech
Chart Utilities

PTS Waterfall Chart Utility
PTS Cluster-Stack Column Chart Utility
PTS Box and Whisker Chart Utility
PTS Marimekko Chart Utility
PTS Dot Plot Utility
PTS Cascade Chart Utility

Subscribe

Site search

Subscribe

Site search


Recent Posts

Recently Commented

Popular Posts

Archive


 

Categories


 

Buy me a coffee

If this topic or the whole blog has been helpful, support further development by treating me to a cup of coffee.


Privacy Policy

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

Pie Chart Traffic Light

by Jon Peltier
Thursday, May 29th, 2008
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

The information aesthetics blog described an interesting use for a pie chart: directing traffic. In marshalite alternative traffic light, there was a picture and short description.

“an alternative, rotary traffic signal designed by Charles Marshall in 1936 & used from the 1940s through 1970s in Australia. 2 rotors pointing at colored sections denote whether traffic in either direction should proceed, prepare, or stop. based on a traditional clock face, it has the advantage of clearly showing signal phase timing.”

Marshalite Traffic Signal

This type of signal has advantages and disadvantages:

  • advantage: shows the timing of the green-amber-red cycle
  • disadvantage: transition between phases is not as distinct as changing lights
  • disadvantage: doesn’t allow for sensor-driven dynamic timing
  • disadvantage: mechanical devices are typically more prone to failure than electronic ones *
    * probably not a factor in 1936

The photo came to information aesthetics via Wikipedia.

Photo Copyright © Dysprosia, all rights reserved. Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:

  • Redistributions of source code must retain the above copyright notice, and this list of conditions;
  • Redistributions in binary form must reproduce the above copyright notice, and this list of conditions in the documentation and/or other materials provided with the distribution;
  • Neither the name of Dysprosia nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior written permission.

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 derek
Time: Friday, May 30, 2008, 1:59 am

I would have preferred that instead of the colored disk being fixed behind a rotating indicator, the disk had rotated behind a fixed mask, so that only one color was visible at a time.


Comment from Jon Peltier
Time: Friday, May 30, 2008, 6:41 am

Derek – That sounds like the traditional colored light signal. I think that would eliminate the benefit of seeing the overall cycle, without eliminating any of the drawbacks.


Comment from Tony Rose
Time: Friday, May 30, 2008, 9:05 am

Did they use Xcelsius to make that? ;)


Comment from Rod McInnis
Time: Friday, May 30, 2008, 1:42 pm

You can’t post something like that without instructions on how to duplicate it in Excel!


Comment from Eric
Time: Friday, May 30, 2008, 1:58 pm

In several Chinese cities, countdown clocks beside vehicle traffic signals (but interestingly, not pedestrian walk signs) are common at super-congested intersections.


Comment from Jon Peltier
Time: Friday, May 30, 2008, 2:03 pm

Eric -

You see countdown timers on pedestrian signals now very frequently in the States, so they know how much longer they have to get across and the drivers know when to start revving their engines.


Comment from Jon Peltier
Time: Friday, May 30, 2008, 2:05 pm

@Rod “You can’t post something like that without instructions on how to duplicate it in Excel!”

You need some electric motors, wire, sheet metal, screws, and paint…


Comment from Eric
Time: Friday, May 30, 2008, 3:54 pm

Jon,

Here in Canada, we have those pedestrian clocks too, but, in many cases, there’s not much of a relation between when the traffic light goes green and when the pedestrian clock reaches 0.


Comment from Tony Rose
Time: Friday, May 30, 2008, 4:02 pm

LOL @ Jon!

Touche

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

PTS Waterfall Chart Utility PTS Cluster-Stack Column Chart Utility PTS Box and Whisker Chart Utility PTS Marimekko Chart Utility PTS Dot Plot Utility PTS Cascade Chart Utility

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