Excel displays percentages of a whole using pie charts, also known as wedge charts of circle graphs. Businesses tend to rely on such charts. The diagrams appear cluttered when graphing many items ...

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.

The Pointy Haired Dilbert blog runs down the details of this nifty Excel trickery, which uses a formula and an image to conditionally show or hide the chart —neat stuff sure to impress the boss.

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: ...