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 firstname.lastname@example.org
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.
Click here to see the details, and download the sample file: Use MAX and IF With Multiple Criteria
More Excel Tips
Here are a few more Excel articles that I read this week, that you might find useful:
- It doesn't have to be complicated! Learn an easy way to make bullet charts and boxplots in Excel, on the Excel Charts Blog
- Instead of using macros, add a hyperlink to a shape, for workbook navigation. Mynda Treacy shows the steps.
- If you need to calculate the last day of any month, you can use Chandoo's simple formula.
- 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.
Recommended Excel Tools
In addition to all the free Excel tips and tutorials, there are other Excel tools that you can invest in. To learn more about the products listed below, click on the links to take a look at their features, and decide if they're right for you.
- Contextures PivotPower Premium Add-in
- Contextures 30 Excel Functions in 30 Days
- Excel Online Course
- Excel Charting Tools
- Excel Dashboard Kits
- Excel Project Management Templates
- Excel VBA School
Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2017
All rights reserved.