Daily posts of Excel tips…and other stuff
Archive for the ‘Charting’ Category.
Because I have no clue. It’s from an university alumni magazine. The names I’ve smudged (or tried to anyways) are the various colleges. Could this graphic be done in Excel? Yes. Should it?
Tushar Mehta (www.tushar-mehta.com)
When Excel creates a chart it assigns, by default, certain physical dimensions to the chart. These physical dimensions (height and width) are independent of the logical content of the chart. So, in the case of a column chart the physical shape of the chart is the same irrespective of whether it contains 2 [...]
Everyone is sick of talking about how pie charts suck. And whenever I do a charting post, it’s trouble. So this post is destined for failure. However, I was thinking about pie charts recently. I don’t have the disdain for pie charts that some do, but I generally agree with the [...]
Peter King at SI says:
The NFL has a slotting system that is ever-so-slightly malleable, where a player who gets drafted one spot lower than another player occasionally gets a smidgeon of a better deal. And sometimes a quarterback gets an above-market deal. But position players and non-quarterback skill players are slotted, and despite the efforts [...]
Inspired by Dick’s interest in charts, I took a look at how I would have presented the data.
Some overall thoughts. I used Office 2010 beta for the charts shown below. There was not much, if any, difference between what I would have got with Excel 2007. I also stayed with the default [...]
After week 8 of my golf league, I decided to have a chart-of-the-week. Now, for the first time ever, you can view all the charts o’ the week in one place with author commentary.
Week 8
After scoring week 8, I noted that I was plummeting down the leaderboard while Miller seemed to be scoring well [...]
From Philip Greenspun
You draw a line from the current weight/date to the desired weight/date. Every morning you weigh yourself and plot the result. If the point is below the line, you eat whatever you want all day. If the point is above the line, you eat nothing but broccoli or some other low-calorie food.
The thing [...]
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 [...]
