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
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
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
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
Here are a few more Excel articles that I read this week, that you might find useful:
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.
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.
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.
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.