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 build-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
Recommended Excel ToolsThey aren't free, but these Excel tools are a worthwhile investment, so please click on the links to take a look at their features, and decide if they're right for you.
- Contextures 30 Excel Functions in 30 Days
- Excel Charting Tools
- Excel Dashboard Kits
- Excel Project Management Templates
- Excel VBA School
- Excel Pivot Table Intro Course
Note: I am an affiliate for the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2014
All rights reserved.