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...
How to Reproduce Your Excel Work Across Many Categories, Part 3 of 3
Part 1 of this series about analytical spawning with Excel described how Excel users often need to spawn one model or report across many related...
This Excel Analytical Charting Strategy Reveals an Economic Warning
With normal charts, you find data and then you plot it. But with analytical charts, you transform your data in various ways to discover...
The First Excel Dashboard Report Shown in Public
Tektronix invented one of the early moderately priced color printers. When one of their employees saw a sample of my Excel dashboards from 1992, the...
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...
How to Audit and Improve Excel Business Plans
A client, who's a business-finance consultant, recently was hired to improve the financial forecast for a major startup company. He recently sent me the...
Professional Quality Excel Chart Labels, Legends, and Colors
The following Excel chart shows that Excel really CAN generate professional-quality chart figures.
Here are some general strategies to consider…
1. Set up your data-plumbing correctly....
Excel Bar Charts with Economic Indicators
The Excel figure below shows three indicators of the US economy. Two show economic improvements and one doesn't.
The Excel Perspective
Using column charts rather than...
Show Key Stats Automatically in Periodic Excel Reports
Each issue of Business Week magazine used to include several figures titled "The Stat". These figures emphasized key data related to the article on...
Three Charts Showing Covid-19’s Economic Damage
The following Excel figure shows three indicators of the US economy.Chart 1 measures the number of new unemployment claims during the past...