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 ddalgleish@contextures.com

Fun With Pizza Pie Charts

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

Dashboard Course and Tools

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.

Show Text in Excel Pivot Table Values Area

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

Worksheet Form Controls

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

More Excel Tips

Here are a few of the Excel articles that I read recently, that you might find useful:

Other Excel Articles

Here are a few of the Excel articles that I read last week, that you might find useful:

Video: Pivot Grouping Problems

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.

Winter Returns

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!


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.




Privacy Policy


Contextures Inc., Copyright 2019
All rights reserved.