Sunday, October 25, 2020
Home Business & Economics Analytical Charting

# Analytical Charting

Articles about using Excel charts to find insight in data.

### Find Leading Indicators Using Automated Cross Correlations in Excel, Part 2

In Part 1 of this discussion about automated cross correlations, I explained how to set up  the cross-correlation Data Table shown below, in columns...

### Excel Charts, Seasonality, & Analysis: Five Lessons from the WSJ

A 2009 article in the Wall Street Journal offered some great advice for Excel users in business. The article, New Light on the Plight of...

### Should You Raise Prices? Should You Lower Them? These Excel Charts Can Help You...

In the early 1980s I was the CFO of a company owned by a man whose first instinct was to cut prices. When business was...

### Three Simple Tricks to Improve Analytical Charting in Excel

For years, my Excel charts of trends used a simple idea: To gain insights about periodic data, just chart it. What else was there to...

### Find Leading Indicators Using Automated Cross Correlations in Excel, Part 1

It all seems so simple... To improve your forecasts of sales or other measures, you simply need to find leading indicators...measures that are highly correlated...

### Introducing the Power of Year-Over-Year Performance Charts in Excel

The purpose of management reports should be to help readers find and track patterns of performance…quickly and easily. That’s the attraction of charts, of course....

### Map Costs and Sales in Excel with a Classic Breakeven Chart

When I worked as a CFO, my monthly reports always included a breakeven chart. It was one of the most popular reports I produced. But...

### Calculate Mortgage Payments and Your ROA with an Excel CalcPlot Chart

An Excel CalcPlot Chart allows you to plot values in three dimensions, not merely two. Here are two examples. Mortgage Paments Mortgage interest rates are at...

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

### An Introduction to Excel Data Plumbing

Would you like to: Create your new reports, analyses, forecasts, and other Excel work quickly? Update your Excel work with one command, without using...

### How to Be Significantly More Productive in Excel

The Excel charts below are professional-quality. But that's not what makes them so unusual. Instead... ● You can update them in a few seconds, with...

### Learn How to Use Excel to Track the US Recovery from the Covid Recession

The Covid recession is the worst recession the world has experienced since the Great Depression. And the Recovery Tracker workbook and Excel training can...