Search Contextures Sites

 

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

30 Excel Functions in 30 Days

 

 

 

Contextures News

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 List

My 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 Tools

They 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.

Note: I am an affiliate for the products mentioned in this newsletter, and earn a commission on the sales.

 

 

Privacy Policy

 

Contextures Inc., Copyright 2014
All rights reserved.