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 firstname.lastname@example.org
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
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
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
Here are a few of the Excel articles that I read recently, that you might find useful:
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.
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.
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 ©2018
All rights reserved.