Archive for Choose the Right Chart - page 3

Bar Charts: Regular or Stacked?

Bar Charts: Regular or Stacked?

Chart choosing is part art and part science. During workshops, I cover my chart choosing thought process in more detail. For now, let me save you hours of time with this not-so-secret secret: Start with a bar chart. Then, fine-tine your bar chart. Try your…

Continue reading →

The Axis: Actual Maximum Value or Potential Maximum Value?

The Axis: Actual Maximum Value or Potential Maximum Value?

Fine-tune your graphs by discussing this question with your colleagues: should our graph’s axes extend to the dataset’s actual maximum value or to the potential maximum value? Option A: Axis stretches just past the actual maximum value (30% in this example) The biggest number is 26%, and…

Continue reading →

Removing the Double Y Axis

Removing the Double Y Axis

My least favorite charts of all time include clustered bar charts, 3D exploding pie charts, and line charts with two y axes. By now, hopefully you know my style. I’m not just going to complain about a graph without offering an alternative. Sometimes we need…

Continue reading →

The Simplest Excel Hack You’ll See Today

The Simplest Excel Hack You’ll See Today

In my prior post, I sketched a few options for a performing arts organization’s fictional ticket sales data:   I intentionally separated the year-by-year bars from the total bar with a little extra space. I don’t want all the bars mushed together. Easy to sketch…

Continue reading →

How the Sketching Process Works

How the Sketching Process Works

I’m back from a brief blogging break! I’ve spent the past few months speaking and designing – mainly designing. The reports and slideshows I’ve consulted on are starting to be published and it’s been so rewarding to watch organizations’ drafts transform into well-articulated masterpieces.   A…

Continue reading →

Page 3 of 8 1 2 3 4 5 ... Last →