Archive for Choose the Right Chart - page 3

Bar Charts: Vertical or Horizontal?

Bar Charts: Vertical or Horizontal?

“Ann, should my bar charts be horizontal or vertical?” Ordinal variables get vertical bars Ordinal variables follow a natural progression—an order. I arrange ordinal categories from left to right so my viewers can view the sequence across the page, which means their bars are vertical. Use…

Continue reading →

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 →

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