Search Contextures Sites
Excel Weekly News from Contextures Aug 8, 2012
Create an impressive panel chart, highlight next month's dates in a pivot table, and other tips, in this week's Excel news from Contextures.
How to Create a Panel Chart in Excel
A panel chart looks like two or more individual charts, but it's built in a single Excel chart.
This technique is certainly more complicated than a simple line chart, but I've broken it into steps that you can see in the blog article and video.You can read the detailed instructions on my Contextures website:
Select Multiple Names from a Drop Down ListMy data validation article was posted on Microsoft's Excel blog last week, describing how to select multiple items from a drop down list.
You can read the article here: Select Multiple Names from a Drop Down List
I've written about this technique previously, on the Contextures blog, and gave it a fresh approach for Microsoft's visitors. You can read more about it on my Contextures website: Excel Data Validation - Select Multiple Items
Format Pivot Table to Highlight Dates
With conditional formatting, you can highlight specific dates in an Excel pivot table. In this example on my Pivot Table blog, I highlight the dates for the upcoming month.
Click here to see the instructions, and be sure to read the warnings at the end of the article, about adjusting the conditional formatting range: Format Pivot Table to Highlight Dates
Edit Excel 2010 List Data in a Popup Form
Use the built-in data form to edit Excel data in a popup form. No macros are required for this trick.
Click here to read the instructions on my Contextures blog: Edit Excel 2010 List Data in a Popup Form
Change Pivot Table Report Filters With VBA
Change one report filter in a pivot table, and programming changes another filter automatically, in the same pivot table.
Click here to read the article, and get the download link: Change Pivot Table Report Filters With VBA
Microsoft Excel Check List Template
On his Clearly and Simply blog, Robert Mundigl has created a free Excel template for a structured Checklist. It gives you the option to check and uncheck by double clicking.
Click here to read the details and download the free template: Microsoft Excel Check List Template
Save time with our "Done For You" Excel products.
- Pivot Power Premium Add-in - Time-saving tools for pivot table users
- Data Entry Popup Kit - Quick and easy data entry with a popup list
- Data Entry Search Popup - Enhanced data entry popup, with Search box
- Excel Tools Add-in - Make instant backups, sheet list with links, much more
- More Excel products from Contextures
Note: I am an affiliate for the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2018
All rights reserved.