Excel Weekly News from Contextures Nov 26, 2013

Improve a pie chart + more Excel tips

In this week's Excel news, you'll see how to build a better pie chart, and other tips. Thank you for reading the Excel news!

-  Debra ddalgleish@contextures.com

## How to Make a Pie Chart in Excel

A pie chart is not the best way to present data in Excel, but sometimes you need to build one. When you do, make sure that it is not too crowded, and the information is easy to understand.

Click here to see the details, and watch the video: How to Make a Pie Chart in Excel

## How to Show Missing Items in Pivot Table

In a pivot table report, if a customer has not bought a specific product, that item won't appear under the customer's name. However, you can make every product appear for every customer, by changing a pivot table setting.

For new products, that no customer has purchased, a temporary record can be added to the source data.

Click here to see the details, and watch the video: How to Show Missing Items in Pivot Table

## Use MAX and IF With Multiple Criteria

Last week, we used the MAX and IF functions to find the latest date that a product's price was changed. This week, we're adding the customer name to the criteria, then we'll find the latest price for the product and customer.

## More Excel Tips

Here are a few more Excel articles that I read this week, that you might find useful:

1. It doesn't have to be complicated! Learn an easy way to make bullet charts and boxplots in Excel, on the Excel Charts Blog
3. If you need to calculate the last day of any month, you can use Chandoo's simple formula.
4. Finally, for a humorous peek at what other people are saying about Excel, read this week's collection of Excel tweets, on my Excel Theatre blog.

## Video: Create Multiple Pivot Table Subtotals

Subtotals are automatically added in a pivot table, and you can add more, with a couple of simple steps. This short video shows the steps, and you can read more about subtotals on my website.

## Stained Glass Leaves

It was cold and damp this week, so we did an indoor art project one day, after gathering a few leaves in the nearby park. The leaves, and a few broken crayon bits, were placed on wax paper, with another sheet on top. A warm iron stuck everything together, and we hung the "stained glass" in the window, where it looked very pretty.

___________________________

### Contextures Products

Save time with our "Done For You" Excel products.

Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.

________________________

__