Excel Chart Compares High and Low Scores

Win loss high low chart http://blog.contextures.com/

Last weekend, I helped someone who needed a chart for a fantasy football league, to show the highest and lowest win/loss scores for each week. To help explain what it should look like, they posted a picture of a hand drawn chart, similar to the picture below.

By the way, I created the sketch in Excel, by using the Marker option, in the Artistic Effects. Who knew that Excel was so artistically talented?

Continue reading Excel Chart Compares High and Low Scores

Excel Roundup 20141020

In this video, sports scientist, John Lythe, shows how you can create 4 dynamic Excel charts in 10 minutes.

Or watch on YouTube: Make Four Dynamic Excel Charts in 10 Minutes

Continue reading Excel Roundup 20141020

Excel Report Diagnostic Display

excel diagnostic report http://blog.contextures.com/

Did you ever print and distribute pivot table reports in Excel, only to discover – too late – that they weren’t showing the correct information? To help save you from wasted time and paper, and possible embarrassment, AlexJ is sharing his Report Diagnostic Display technique today.

You might remember some of his other handy tips, such as

Set Row Height With REPT Function Use Slicers to Filter a Table in Excel 2010

Before you read the rest of this article, remember that the 20% discount ends today, Oct. 16th, for Mynda Treacy’s Excel Dashboard course. To get a bonus of

Continue reading Excel Report Diagnostic Display

Excel Roundup 20141013

Weekly Excel Roundup http://blog.contextures.com/

The Power Map feature was improved last month, and this short video shows some of the things you can do with custom maps in Excel.

Or watch on YouTube: 6 Cool Ways To Use Custom Maps in Power Map

Continue reading Excel Roundup 20141013

Mysterious Excel 2013 Filter Problems

http://blog.contextures.com/

A couple of days ago, I had problems while trying to run a simple macro in Excel 2013. Things didn’t go too well, and it took me quite a while to solve the problem. You can read the details below, and I hope it helps, if you ever run into a similar error.

I also have a couple of announcements, before you read the mystery of the misbehaving macro:

From Oct. 8-10, Jan Karel Pieterse is offering a 50% discount on his Formula auditing tool, RefTreeAnalyser. Enter the coupon code: MVP2014 Mynda Treacy’s Excel Dashboard course is open for registration.

Continue reading Mysterious Excel 2013 Filter Problems

Excel Roundup 20141006

Weekly Excel Roundup http://blog.contextures.com/

In this video, Annie Cushing shows how to create a scrolling table, by using the INDEX function and a scroll bar form control. This technique would work nicely in a dashboard, where space is limited.

For more dashboard tips, take a look at Mynda Treacy’s Excel Dashboard course which has just opened for registration, until Oct. 23rd. Details are in the Announcements section, below.

Continue reading Excel Roundup 20141006

Add Your Own Icon to an Excel Custom Ribbon Tab

Are you building custom tabs for your workbooks yet? Last year, I wrote a couple of articles about custom tabs:

Custom Ribbon Tab for Excel File – how to open and edit the Ribbon Code Add Custom Ribbon Tab to Excel Workbook – create a custom tab and add buttons

In the screen shot below, you can see the custom tab that appears on the Ribbon when the Order Form workbook opens. The buttons make it easy to clear the data entry cells, and print a completed order form.

Create an Icon

Today, you’ll see how to create your

Continue reading Add Your Own Icon to an Excel Custom Ribbon Tab

Excel Roundup 20140929

conditional format color

I’ve seen lots of non-spreadsheet items with “Excel” in their names, such as gum, and bowling gloves, and hand dryers.

However, this is the first time that I’ve seen a product named after a pivot table. Do you think that they help you analyze your data more efficiently? I wonder if they have a women’s version too.

Kenneth Cole REACTION Men's Pivot Table LE Oxford

Contextures Posts

Here’s what I posted recently:

Color data entry cells with conditional formatting, to make them easy to find Use GetPivotData function to pull the total amount from a pivot table on specific

Continue reading Excel Roundup 20140929

Show Color With Conditional Formatting

conditional formattin color http://blog.contextures.com/

I like to color data entry cells, so they’re easy to spot on an Excel worksheet. If you know that you should type a value in every blue cell, it’s quicker, and safer, to fill in a worksheet.

Recently, I was asked how to color a specific number of data entry cells, based on a number that someone selected from a drop down list. So, instead of manually coloring the data entry cells, I used conditional formatting to color them.

In the screen shot below, 3 was selected in cell C2, so 3 data entry cells are blue, in cells

Continue reading Show Color With Conditional Formatting

Excel Roundup 20140922

excel jambalaya calculator http://blog.contextures.com/

If you love Jambalaya, you’ll appreciate the Excel Jambalaya Calculator that Jay Crush has worked on for several years. He just released version 7.0, and you can read about the calculator, and get the file download link, in Judy Walker’s article in the New Orleans Times-Picayune.

I downloaded the file, and you can see a screen shot below. Now, if 150 people drop by for dinner, I’ll be able to cook up a giant batch! Please call ahead, to let me know if you’d like a full plate, or just an 8 oz bowl.

Continue reading Excel Roundup 20140922