Archive for Choose the Right Chart - page 5

Be Careful with the Y-Axis…

Be Careful with the Y-Axis…

I was recently working with an organization to improve their graphs for an upcoming conference presentation. Notice anything funny about the height of these bars? The shortest bar, for 2012, represents 26,000 youth. But the tallest bar, for 2010, represents 27,000 youth. 26,000 and 27,000…

Continue reading →

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 →

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