excel

I was asked recently if it is possible to make this graph in Excel. It’s just a simple line chart with the data labels placed on the point instead of above or below, as is the usual case. I generally…

Last week, I showed you how to use Excel’s Conditional Formatting menu to add cell formats to highlight specific data values. Here, I’ll show you how to easily use the Color Scales options in that menu to create a Heatmap….

Last week, I wrote about how to make a slope chart in Excel when the data series are in different units. Today, I’ll use those same data to show you how to use Excel’s Conditional Formatting menu to highlight your data….

I was recently asked to create a series of Excel graph options for what I’d consider a relatively small dataset (but sometimes the small datasets are the hardest to visualize!). The data consisted of a measure of life expectancy and…

I was at a conference earlier this fall and someone asked me whether it’s possible to create an Excel chart where only the first (top) y-axis label has a percentage sign format while the others were just number labels. In…

My friend Stephanie Evergreen–who co-hosts the awesome Rad Presenters Podcast with me–published a post last week about labeling charts in Excel. In it, she offered some guidance about how to get rid of your default legends and directly label your charts…

Creating bullet charts in Excel can be a bit tricky. This slidedeck lays out a step-by-step approach to creating bullet charts in Excel. The approach was first made public by Jorge Camoes. An alternative version was published in early 2011…