Archive for the ‘Charting’ Category.

Reading XML Files in VBA

In Creating State Maps... I copied some data out of an XML file and graphed it into a state map. I wanted to try to read the XML file directly in VBA because I've never done it before. First, I set a reference to Microsoft XML v6. Six was the newest version [...]

Creating State Maps with XY Charts

According to eggheadcafe, Excel doesn't have built-in maps anymore. I'm not a charting guy, as you know, so I didn't know that. I also didn't know that they ever did. But I wanted a map of the US with sales by region. That seems possible, but all I got this time [...]

Data Sets

I like finding data sets on the internet. Like at mathforum.org and other resources at mathforum.org. Now we can answer the age-old questions like, Where do women outlive men by the largest margin?

I guess they kept the women-folk away from Chernobyl. It does raise the question of why I can't prevent Bangladesh's [...]

Historical U.S. Tax Rates

I heard a lot of news about 'tea parties' going on yesterday. If you don't know, tea parties are supposed to mimic the Boston Tea Party, where New Englanders complained that they were paying tax, but had no say in government, i.e. taxation without representation.
That got me wondering why people would be participating in [...]

Green Eggs and Ham

via Kottke
After writing The Cat in the Hat in 1955 using only 223 words, Dr. Seuss bet his publisher that he could write a book using only 50 words.
Except that the website with the text has a typo which puts the word count at 51. At least that's what I think. I don't [...]

Excel Movie Reviews

I recently watched The Contract. It was terrible. It was worse than The House Bunny (my wife picked that one, I swear). You're probably saying, "I like John Cusack. I like Morgan Freeman." Yes, they're good. Everyone else in the movie is terrible.
How does a really bad movie become [...]

Counting Olympic Medals

I saw this article in the LA Times about measuring Olympic Medals per capita. I like the idea, but I also think figuring in the GDP of the country makes sense. The US could throw a lot of money at an individual event and probably fair pretty well.
I got the GDP via Wikipedia [...]

Peltier Loves Pie

I'm testing out widgenie (beta) and want to see how an embedded chart looks. I chose a pie chart because I've been reading lately how we all know pie charts are bad.
Anyway, this took about 10 seconds to create with Debra's sample data.

var myLogiWidget477e7c06_b129_47f5_b60b_617dfb112792 = new rdLogiWidget;
[...]