Search Contextures Sites


Newsletter Index


Excel news
by email




30 Excel Functions in 30 Days




Contextures News

Excel Weekly News from Contextures Apr 30, 2012

Show hidden data in a chart, troubleshoot a macro, get a gentle introduction to arrays in VBA, and other tips, in this week's Excel news from Contextures.

 -  Debra

Change setting to show hidden data in Excel chart

If you build an Excel chart from worksheet data, then hide some of the data's rows or columns on a worksheet, the data disappears from your chart.

By default, charts don't display the data in hidden rows and columns, but you can change a setting to make the data appear in the chart.

Click here to find that tip, and many others, in my Excel Frequently Asked Questions (FAQ) section on the Contextures website.

Troubleshooting a Macro Error

I had problems with a simple macro last week, and finally figured out what the problem was. You can read about the problem and solution in my blog post -- When Good Excel Macros Go Bad

There's a video in the blog post too, that shows the problem and solution.

Click here to read the article and see the video: When Good Excel Macros Go Bad

Create a Dynamic Drop Down List of Dates

With Excel functions and data validation, you can create a dynamic drop down list of dates, such as Last Monday, This Monday, Next Monday.
Click here to see the steps for setting up the dynamic dates, and the drop down list to select one of the dates: Create a Dynamic Drop Down List of Dates

Hidden Pivot Table Calculated Field Command

On the Bacon Bits blog, Mike Alexander has a quick tip for adding calculated items or calculated fields to a pivot table.

Click here to read Mike's tip: Hidden Pivot Table command

Create Pivot Table Named Ranges

To pull data from a pivot table, Doug Glancy created named ranges based on the pivot table fields. See how he did it, in his YourSumBuddy blog post.

Click here to read Doug's instructions: Create Pivot Table Named Ranges

Modifying spreadsheet data with VBA - the quick way

In his Newton Excel Bach, not (just) an Excel Blog, Doug Jenkins shows us how to use arrays in Excel programming, to make a data updating job go much faster. "In this case a 7 minute task was reduced to less than half a second, about 1000 times faster!"

It's a short example macro, and easy to follow -- not one of those long VBA examples that just makes your head hurt -- so go and take a look.

Click here to see Doug's VBA example: Modifying Data With VBA

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.

Learn how to create Excel dashboards.


Privacy Policy


Contextures Inc., Copyright 2014
All rights reserved.