Wednesday, May 31, 2023
Home Excel Methods Charting Methods

# Charting Methods

All about creating, using, setting up, and improving Excel charts.

### Chart Recessions and Other Boolean Conditions in Excel

I doubt you’ve seen an Excel chart like this before. It shows multiple Boolean conditions that might affect the trend in the annual Rate...

### Five Ways to Calculate Frequency Distributions in Excel

Walt captures blood-pressure readings and wants to find how often the readings fall into various ranges of values. This is a common need for a...

### Three More Simple Tricks to Improve Excel Charts for Business

In 3 Simple Tricks to Improve Analytical Charting in Excel, I showed you how to shift time periods, index your data, and chart your rate...

### Dashboard-Like Excel Charts of International Consumer Confidence

The following Excel figure displays its charts in a dashboard-like format. At least, it's in a format that dashboards should use! When you use simple...

### How to Make Top-Ten Charts Easier to Read

Managers need to know where the greatest opportunities and the worst problems can be found. This is why top-item figures are so popular. These figures...

### Show Useful Year-to-Date Variance Charts in Your Excel Dashboards

Many companies have a difficult time creating charts of spending variances. In fact, many companies rely on charts that are nearly useless for that...

### Two Business Uses for Excel’s New Chart Feature

For decades, I've been whining about the need for Excel to have some way for our formulas to specify a gap in line and...

### How to Create Funnel Charts in Excel

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...

### How to Remove a Speed Bump From Your Excel Charts

Because managers need QUICK insight, we should remove as many speed bumps as possible from our reports and analyses. The following figure with two Excel...

### Compare Metrics by Category Using Excel Dot Plot Charts

Management reports often must compare measures of performance by some type of category. For example, reports could compare sales by product, variance by department, sales...

### How Fast Is Too Fast?

(Originally published in Inc Magazine.) What typically tops the list of worries of the chief executive officers of fast growing companies? Financing that growth, according...

### How to Smooth Data by Using the TREND Function

Years ago, I read that Prof. William S. Cleveland had suggested that data could be smoothed by calculating a centered trendline through adjacent data—a...

### Consumer Sentiment Suggests a 2022 Recession

In recent months, business websites have speculated about recessions and stagflation in 2022. These predictions could affect your Excel work significantly in the next few...