Saturday, September 24, 2022
Using the right Excel charts to display year-to-date variances can clarify budgets and spending problems. But using the wrong charts is a waste of time.

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...
Three More Simple Tricks to Improve Excel Charts for Business

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

Add Low-Overwhelm Context to Your Line Charts

The data you display in charts often takes on new meaning when you display it in the context of other data. One way to add...
You can uncover new insights about your company by transforming your data before you chart it. This method of data transformation has revealed a long-term weakness in the U.S. economy.

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

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...
This Excel chart of High-Low-Open-Close stock data shows key methods you can use in charts...even those that have nothing to do with the stock market.

Using Excel XY (Scatter) Charts for Stock Analysis with HLOC Plots

One way to improve your abilities in Excel is to improve your understanding of the kinds of solutions Excel can generate when you use—or...
When you include recessions and economic downturns in your charts, you can show your company's performance in a much better context. Here's how to set up your Excel charts to display those recessions and downturns.

How to Show Recessions in Excel Charts

I showed you the following figures in Chart Your Rate of Change to Reveal Hidden Business Performance. The line in the first chart below shows Apple's...
How to calculate and highlight the standard error of the estimate on each side of the trend in an Excel chart to make exceptional results stand out.

Highlight Normal Results in Line Charts to Make Exceptional Results Stand Out

Line charts that show trends in performance are the most useful type of chart that management reports can contain. All managers want good performance to...
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

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...
The two Excel dashboard-like charts with May data show that consumer confidence has dropped like a rock since March. But Asia's data isn't available yet.

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

Latest Articles

Growing too fast can be dangerous to your company's health. Use the Sustainable Growth Rate ratio to track your company's financial ability to grow.

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...
Two economists have introduced a new leading indicator, which predicts a recession soon. These Excel charts illustrate their insight. If they're correct, Excel users will be very busy in the months ahead.

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