Excel Weekly News from Contextures Apr 22, 2014
Text in pivot table values + more Excel tips
In this week's Excel news, you'll see how to show text in a pivot table's values area, and other tips. Thank you for reading the Excel news!
- Debra firstname.lastname@example.org
There's usually a better way to show data, instead of a pie chart. In this case though, I think we can make an exception -- this is a pizza pie chart! Instead of the default colors, you can add a picture to each slice, to show the favorite toppings.
Click here to see the details, and watch the video: Make a Better Pizza Pie Chart
Those pizza pie charts probably wouldn't be the best choice for a corporate dashboard, unless you work at a pizza company! If you'd like to improve your dashboard skills, Mynda Treacy from My Online training Hub is opening her Excel Dashboard Course, and if you sign up by May 1st, you can get the course for 20% off.
I've been through this course, and highly recommend it. The course is video based, delivered online and is available 24/7. You'll receive comprehensive workbooks and sample dashboards to keep, and there's even an option to download the videos.
Bonus: If you sign up for Mynda's course through one of my links, I'll send you a copy of the time-saving DataPig Dashboard Tools add-in. Just enter the Referral Code – DebraD – in the box just below the Buy Now button. You can see the Dashboard Tool key features in this very short video.
Usually you can only see numbers in a pivot table's values area, even if you put a text field there. But, with conditional formatting and custom number formats, you can magically change those numbers into text. In the screen shot below, the region numbers 1 and 2 have been changed to text, and I'm about to fix #3.
Click here to read the details, and watch the video: Show Text in Excel Pivot Table Values Area
Last week, Chandoo interviewed me for his Excel podcast, and you can tune in, to learn about working with Form controls. See if you can catch my mistake, before I do!
Click here to see the details: Adding Form Controls on a Worksheet
Here are a few of the Excel articles that I read recently, that you might find useful:
Here are a few of the Excel articles that I read last week, that you might find useful:
If you create two pivot tables from the same source data, and group the dates in one pivot table, those dates will be automatically grouped in the second pivot table, because they share a pivot cache.
In this Excel video tutorial, see the simple steps for creating a second pivot cache, so the two pivot tables can have different date groupings.
Last week, while I chatted with Chandoo on Skype, for his Excel podcast, it was snowing here in Canada. Where did spring go? I should be seeing blossoms in my backyard in April, not piles of snow!
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.
Contextures Inc., Copyright ©2019
All rights reserved.