PTS Blog

Main menu:

PTS Utilities

Commercial Utilities developed by Peltier Technical Services

  Waterfall Chart

Excel Books

Books that I own and use while developing in Excel

Goods and Services

Excel or charting related products and services which I use or feel are worthwhile additions

Subscribe

Site search


Recent Posts

Recently Commented

October 2008
S M T W T F S
« Sep    
 1234
567891011
12131415161718
19202122232425
262728293031  

Archive


 

Categories


 

Archive for 'Real World Applications'

Graphical Approach to a Simple Physics Problem

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

My daughter asked me about her physics homework the other night. The problem was to determine the relationships describing how long it takes water to drain from a hole in the bottom of a bucket given various hole diameters and initial water heights. Given the derived relationships, the student was to determine the time to [...]

Rolling Wheel Animation

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

A college science professor named Roger Blickensderfer wrote to me about an animation he was working on. He wanted to trace the path followed by a point on the rim of a rolling wheel. Roger had cobbled something together, and I fiddled with it, and it kind of worked. But I decided I wanted it [...]

Gas Prices - Interactive Time Series

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

In Watch the Rise of Gasoline Retail Prices, 1993 - 2008, Nathan shows an animated bar chart that traces the price of gasoline over the past 15 years. A number of readers responded with links to assorted time series.
I downloaded Nathan’s data workbook and duplicated Nathan’s animated bar chart in Excel in Gas Prices - [...]

Gas Prices - Animated Bar Chart for Excel 2

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

In Gas Prices - Animated Bar Chart for Excel, I duplicated Nathan’s dynamic bar chart of gas prices in Excel.

It’s a pretty nice animation, but there is no sense of where the bar chart is along the date scale of the data. I made a small adjustment to the model above, drawing a small time [...]

Gas Prices - Animated Bar Chart for Excel

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

In Watch the Rise of Gasoline Retail Prices, 1993 - 2008, Nathan shows an animated bar chart that traces the price of gasoline over the past 15 years. Nathan’s animated chart looks like this:

I downloaded his data workbook and went to work duplicating his chart in Excel.

What Goes into the Price of Gas?

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

In Data Visualizations Related to Gas Prices, Tony Rose of Support Analytics Consulting shows a series of visualizations he’s culled from the web, all related to gasoline prices. One infographic stuck out, partly for its overuse of chart junk, and partly for Tony’s interpretation. Here is the original chart, which Tony took from www.thebiblog.com, followed [...]

Pie Chart Traffic Light

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

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 [...]

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