Cahier / Notebook

Oct 05

[video]

Oct 03

Intimate Meal

Intimate Meal

“All truth passes through three stages. First, it is ridiculed. Second, it is violently opposed. Third, it is accepted as being self-evident.” — Arthur Schopenhauer

(Source: cs.virginia.edu)

Oct 02

Morning Sun Palms

Morning Sun Palms

Oct 01

Color Wheel

Color Wheel

Santa Monica Beach

Santa Monica Beach

Sep 29

From the Queen Mary today.

From the Queen Mary today.

Sep 25

Contrast

Contrast

Sep 24

“While we are postponing, life speeds by.” — Seneca

(Source: cs.virginia.edu)

Sep 19

Sometimes our cafeteria still comes through.

Sometimes our cafeteria still comes through.

Sep 14

(via merlin)

Sep 13

Setting Sparkline Axes in Excel 2011

In the course of doing some data modeling this morning, I found myself confused by the default behavior of sparklines in Excel 2011.

As these small charts are useful in making comparisons, it didn’t makes sense that the axes were different for each sparkline summarizing individual rows in a range.

In the above example, the first data point is the same in both rows and should be scale (note is is larger in the second row). Using the “Automatic” setting in Excel (the default mind you), the vertical axis is set independently for each sparkling.

After fixing the problem using the steps below, you can see the difference in the “Same” column. The first data point is now scale and the graphics are useful for comparison.

On the ribbon (in Excel 2011 for Mac at least), click Charts > Sparklines and click Axes to bring up the the settings below:

On the Vertical tab, select “Same for all sparklines” for both Minimum and Maximum values. Clearly this might be different for different uses and formats of sparklines, but for simple comparisons, it would seem that “Same” should be the default.

Sep 07

“The best way to predict the future is to invent it.” — Alan Kay

(Source: cs.virginia.edu)

Sep 02

The Evolution of the Web -

Great interactive visualization.

(Source: Engadget)

Sep 01

fishelville:

For all the app dev folks out there, this is hanging in a few cubicles around the office!  (Taken with instagram)

fishelville:

For all the app dev folks out there, this is hanging in a few cubicles around the office! (Taken with instagram)