Archive for Choose the Right Chart - page 5

Quickly Visualizing Patterns with Excel’s Data Bars

Quickly Visualizing Patterns with Excel’s Data Bars

Data bars are miniature within-cell bar charts. I primarily use them to quickly explore patterns in my dataset. Sometimes I decide to make an actual bar chart of the data later on. Other times, I’m simply using these tiny charts to help my brain spot…

Continue reading →

Adjusting Your Bar Chart’s Spacing in Excel

Adjusting 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 →

Introducing the Essentials, a Chart Choosing Tool

Introducing the Essentials, a Chart Choosing Tool

Last summer, my husband was traveling for work and I had the house to myself for an entire week. I could’ve binge-watched Sex and the City or eaten crumbly crackers in bed, his one-and-only marriage deal breaker. Instead, I designed my own chart taxonomy (while…

Continue reading →

How to Make a Heat Table in Excel

How to Make a Heat Table in Excel

Just because I adore graphs doesn’t mean that I shun data tables. I insert the occasional table inside the body of my report, and each report’s appendices are full of tables, tables, and more tables. When creating traditional tables, I follow the Dark Horse Analytics guide….

Continue reading →

Six Alternatives to the Clustered Bar Chart

Six Alternatives to the Clustered Bar Chart

We can all agree that 3-d exploding pie charts are pretty rotten. My vote for worst chart? The clustered bar chart. I see clustered bar charts everywhere. E-V-E-R-Y-W-H-E-R-E. On pages 1, 2, 3, 4, 5, 6, 7, 8, 9, and 10 of reports. In slides 1, 2, 3,…

Continue reading →

Page 5 of 8 ← First ... 3 4 5 6 7 ... Last →