Format your data as an Excel table (more on that later ... As mentioned, you can also create a custom pivot chart based on specific conditions. In the example below, we will create a pivot ...

Once you've mastered some of the more straightforward Excel charts, try using some that offer more specific functions and ...

2. Open the document containing the data that you'd like to make a pie chart with. Click and drag to highlight all of the cells in the row or column with data that you want included in your pie graph.

For data nerds, Excel's drop-down lists are a lovely gift. They keep entries consistent across multiple rows — no misspelled words or names written without capitalization. Drop-down lists are ...