Excel Weekly News from Contextures May 20, 2014

Compare Years in Pivot Chart + more Excel tips

In this week's Excel news, you'll see how to compare years in a pivot chart, and other tips. Thank you for reading the Excel news!

 -  Debra ddalgleish@contextures.com

Show Drop Down Items in List Box

Instead of selecting items from a drop down list on the worksheet, use a pop-up list box, to make selection easier. You can change the font size, and make the list longer and wider.

Click here to see the details, and download the sample file: Show Drop Down Items in List Box

Compare Years in Pivot Chart

If you're summarizing by date in a pivot table, you'll usually need to group the date field, to get a chart that's easy to read. In this example, the source data contains records from the service department at a manufacturing company. We'll build a chart that compares last year's work order counts to this year's.

Click here to read the details, and watch the video: Compare Years in Pivot Chart

Drop Down Cell Changes Pivot Table

There is a new sample file on my website, and it lets you select from a cell's drop down list. After you select an item, all the pivot tables on that sheet are changed, to filter by the selected item. The file is in xls format, so you can even use it in older versions of Excel..

Click here to see the details: Change Pivot Table Filters With Drop Down Cell

More Excel Tips

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

Video: Select Sections of a Pivot Table

If you're working with a pivot table, you might want to change the formatting for the labels or values in one section. Use the Selection Arrow to select specific sections of a Pivot Table, so you can modify them. See how to turn on the Enable Selection feature, if necessary.

Spring Bouquet

Unfortunately, I wasn't able to attend the Excel Summit in Amsterdam last week, but I did get a lovely bouquet of tulips. It's not quite the same as being there, but it did bring a little touch of the Netherlands into my kitchen.


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.