Search Contextures Sites


Newsletter Index


Excel news
by email




30 Excel Functions in 30 Days




Contextures News

Excel Weekly News from Contextures May 14, 2012

Show hidden data in a chart, use Excel on your iPad, add new items in a UserForm combo box, and other tips, in this week's Excel news from Contextures.

 -  Debra

Show Data From Hidden Rows in Excel Chart

If you hide rows or columns on a worksheet, your Excel chart data might disappear. To prevent that from happening, you can change a setting to make the data stay in the chart.

Click here to read the article and see the steps in a short video: Show Data From Hidden Rows in Excel Chart

Add New ComboBox Items in Excel UserForm

If you want to enter data in an Excel worksheet, while keeping the data sheet hidden, you can create an Excel UserForm. I've updated my sample file, so you can now add new parts to the drop down list, while you're entering data.

Click here to read my article: Add New ComboBox Items in Excel UserForm

How to Use Excel on Your iPad

Did you know that you can use your iPad to view and edit Excel files, without installing any apps? Excel MVP Teylyn shows us how it works.

Click here to read Teylyn's instructions: How to Use Excel on Your iPad

Choose the Right Chart for Your Data

There are many different chart types in Excel, and it can be difficult to choose the best chart type for your data.

On the Lifehacker blog, they discuss the different messages you can show in a chart, and the chart types that best convey those messages.

Click here to read the article, and see the chart type infographic: Choose the Right Chart for Your Data

False Cell or Empty Cell

On the YourSumBuddy blog, Doug Glancy described an Excel problem that he ran into, while trying to use conditional formatting for empty cells. He realized that Excel treats empty cells as equal to FALSE, and that was affecting his formula results.

Click here to see how Doug solved the problem: Oh You False Empty Cell

Interactive Sales Chart using Excel

Last week, Chandoo posted a video about an interactive sales chart in Excel. In his workbook, you can click on any year, region or product name, and the chart changes.

Click here to visit Chandoo's blog, and download the sample file, to see how it works:

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.