Tuesday, June 4, 2024
Home Business & Economics Analytical Charting

# Analytical Charting

Articles about using Excel charts to find insight in data.

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

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

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

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

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

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

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

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

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