Click the first option in the "2D pie" section. Excel creates a pie chart representing the categories as percentages of a 24-hour period. Advertisement. Article continues below this ad.