Does Excel's INDEX worksheet function work for you only some of the time? Here are ways to learn why your INDEX function isn't working as you expect.

How to Debug INDEX in Excel

Excel Methods Charley Kyd - 0
"I'm not a very experienced Excel user. Why does = INDEX(...) sometimes work and sometimes not.... :-)?" -- Suzan G. Probably the best way to...
The word "funnels" is a widely used business term, but Funnel Charts aren't. Here's how and why to set up a Funnel Chart in Excel.

How to Create Funnel Charts in Excel

Charting Methods Charley Kyd - 0
Although “funnels” are a common term in selling, the concept also can apply to other business activities. The general idea is that an organization begins...
Here's one way to highlight exceptional performance in your Excel management reports. You just need an Excel chart, its CHOOSE function, and linked pictures.

How to Create Excel Traffic Lights with Charts and Text

Charting Methods Charley Kyd - 0
"Traffic lights" are a common feature offered by software designed for management reporting and analysis. Traffic lights provide at least two benefits. First, they alert...
When you combine conditional formatting with charts you can create detailed chart legends that match the relative positions of the lines in your chart.

How to Create Dynamic Chart Legends in Excel

Charting Methods Charley Kyd - 0
When I saw a chart designed like the ones below in the Wall Street Journal, I knew I had to create one just like...
If you have seasonal sales, or other measures of performance, Cycle Plots can offer more insight into your performance than traditional charting techniques.

How to Create Cycle Plots in Excel to Chart Seasonal Sales Data

Charting Methods Charley Kyd - 0
If your company's sales are seasonable, you've probably seen a chart that looks something like the first one below. This Excel chart shows the continuous...
Bullet graphs show the same information that dashboard gauges do, but they're smaller and easier to read. Here's how to create your own bullet graphs in Excel.

How to Create Bullet Graphs to Replace Gauges in Excel

Charting Methods Charley Kyd - 0
Business presentations desperately need a replacement for dashboard gauges. Gauges consume too much space in a report. They use excessive "chart junk." They're not...
The extreme variability caused by seasonal sales makes it difficult to track and forecast your underlying sales trends. Here's how to solve that problem.

How to Create a Rolling Forecast of Seasonal Sales in Excel

Charting Methods Charley Kyd - 0
The Excel chart below shows the typical saw-tooth pattern of seasonal sales. Seasonal sales have about the same pattern every year, every week, or both. In...
In a list of items that could appear in a worksheet any number of times, here's how to count the number of items that appear only once. Or twice. And so on.

How to Count the Occurrences of Items in a List

Analytical Methods Charley Kyd - 0
"I have a list of repair orders (RO). I want to know how many one line repair orders there are in the list. So...
When we import data into Excel, dates can arrive in formats that Excel wasn't designed to translate. Here are some ways to make sense of unusual dates.

How to Convert Unusual Date Text Imported to Excel

Dates and Times Charley Kyd - 0
When you import data into Excel, dates often arrive in formats that Excel doesn’t recognize. This is particularly true if your data comes from...
Here's how to split text into columns when you paste the text to your worksheet, and how to turn off this feature when you're done.

How to Change Text to Columns When You Copy and Paste in Excel

Worksheet Interaction Charley Kyd - 0
Today I needed to copy a bunch of numeric tables from a pdf file into Excel. When I pasted the first table, all the data...
1...121314...22Page 13 of 22