Search Contextures Sites
Excel Weekly News from Contextures May 14, 2012Show 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 firstname.lastname@example.org
Show Data From Hidden Rows in Excel ChartIf 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 UserFormIf 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 iPadDid 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 DataThere 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 ExcelLast 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 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.