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

Learn how to show charts with hidden data cells in Excel. When there is data that is hidden in your table, Excel will not show that information in the chart.

You can use the Frequency function within Excel in Microsoft Office 2011 for the Macintosh platform to calculate the frequency of data that lies within a certain range.

Take progress reporting, for example. You're probably used to seeing the status of projects identified in with text descriptions or percentages. But why not show progress with status bars, like this: ...