Quick tip – Combined fields

Quick tip – Combined fields

Suppose you have a chart like this, and someone asks you to make the panes two different colors. You could add the dividing measure (State here) to color, but that would remove the measure already there. What to do? Make a combined field! Add the new field to color, adjust your table calculations, and you're … Continue reading Quick tip – Combined fields

Advertisements

Move Like a Nerd

Big news everyone, I'm starting a new job across the country next month!¬†Naturally, when packing I wanted to keep everything organized with as little work as possible. Here's what the packing process looks like: pack a box slap 4 matching barcodes onto it (top and 3 sides) scan the barcode with my phone log a … Continue reading Move Like a Nerd

Makeover Monday – Revenue per Second

Makeover Monday – Revenue per Second

This week's #MakeoverMonday looks at revenue per second for 25 of the biggest companies. Initial Thoughts The circular orientation of the chart is super misleading! Normally, the angle of the stopwatch would represent time, so on this chart my very first impression is that everything adds up to 45 seconds, which is completely false. If … Continue reading Makeover Monday – Revenue per Second

Makeover Monday – Meat

Makeover Monday – Meat

This week's #MakeoverMonday challenge is about the yearly pounds per capita consumption of various meat products. The original chart is a line graph showing pork, beef and chicken consumption by year. Initial Thoughts Labeling every two years is busy, 5 or less would be better The colors for Pork and Chicken are similar, while the … Continue reading Makeover Monday – Meat

Makeover Monday – Christmas Trees

Makeover Monday – Christmas Trees

It's Makeover Monday time again! This week's original comes from Statista, and shows Millions of Dollars spent on Christmas trees in the United States, partitioned by year and tree type. In my makeover, I took the original stacked bars, and turned that view into a line chart tracking overall tree sales. Then I added a … Continue reading Makeover Monday – Christmas Trees