Tag archive for Templates - page 4

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 Graph’s Scale: Actual Maximum Value or Potential Maximum Value?

The Graph’s Scale: 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 →

How to Adjust Your Bar Chart’s Spacing in Excel

How to Adjust Your Bar Chart’s Spacing in Excel

Let’s pretend you’re graphing age distributions for a given county. You carefully formatted your histogram: you removed the border, lightened the grid lines, wrote a descriptive title and subtitle, selected customized RGB color codes, and called attention to a section of the graph with the saturated action…

Continue reading →

Dataviz Challenge #5: How to Make a Diverging Stacked Bar Chart in Excel

Dataviz Challenge #5: How to Make a Diverging Stacked Bar Chart in Excel

I’ve been in love with diverging stacked bar charts since I saw Joe Mako’s submission to Cole Nussbaumer’s dataviz challenge last December. Joe made this contest-winning chart. But in Tableau! The amazing but expensive software! Could I ever create one in Excel?! Yes! Luckily I’d…

Continue reading →

Dataviz Challenge #4: How to Make a Small Multiples Bar Chart in Excel

Dataviz Challenge #4: How to Make a Small Multiples Bar Chart in Excel

Two weeks ago, I challenged readers to re-create the “after” version of a small multiples bar chart. You can read the full post here. Congratulations to the 6 contestants! Click on the contestant’s name to see their chart. James Coyle Sara Vaca Elisa Avila Angie…

Continue reading →

Page 4 of 4 1 2 3 4