Search Contextures Sites
Excel Weekly News from Contextures Apr 30, 2012Show 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 firstname.lastname@example.org
Change setting to show hidden data in Excel chartIf 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 DatesWith 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 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 Inc., Copyright ©2014
All rights reserved.