A data set that occurs frequently consists of the values or the percentage breakdown of several categories for two time periods. A common way of plotting these data is to use a pair of pie charts.

Excel’s chart features can turn your spreadsheet data into compelling visual communications—if you know what to do. This guide will walk you through the basics of setting up trends, percentages, ...