Sunday, October 17, 2021
With a little creativity in the design of your Excel charts, and in choosing its colors and fonts, you really can create professional-quality results.

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....
Your Return On Equity ratio is a key indicator of financial health. This report lets you show the components of that ratio in a unique Excel display.

Map Your Financial Health With an Excel DuPont Dashboard

Management reporting is all about communication. Reporting Return On Equity (ROE) is a case in point. The ROE financial ratio is a key measure of...
The first time the general public saw Excel dashboards was in 1993 when Tektronix used this report to demonstrate the quality of their printers.

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...
These Excel column charts of employment, business lending, and freight shipments show mixed signals about the current health of the US economy.

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...
Several business magazines offer great examples of how to use charts to communicate business data. But sadly, at times, they show us what NOT to do.

Good Examples of Bad Charts: Chart Junk from a Surprising Source

For years, I’ve written that we Excel users should create “magazine-quality” charts for our reports and analyses. However, we must be very careful of the...

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...
When your Excel formulas get their data from an Excel data worksheet, it's easy to set up weekly dashboard or other reports in Excel.

Weekly Dashboard Reporting with Excel

"I work for a small (private) company whose owners have requested WEEKLY dashboards on various aspects of the business. Do you have a sample...
Here's how a few Excel formulas can move data between Excel's most widely used table designs to transfer data from source files into a more usable form.

How to Read and Update Excel Tables Using SUMIFS and INDEX-MATCH

A growing number of Excel users in business are linking their reports and analyses to Excel tables. By doing so, they can update them...
Excel's Linked Picture feature (Camera tool) allows us to position a table in reports while ignoring the row and column settings in the report worksheet.

Ideas about Using Excel’s Linked-Picture (Camera) Tool

Of all the Excel features that users don’t use very often, Excel's Linked Picture tool probably is the most powerful. This tool, known in...
You can uncover hidden trends by charting the ratio of each month's performance to the same month one year earlier.

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

Latest Articles

To reduce errors in reports, you should foot and cross-foot them. But Excel's floating-point arithmetic gets in the way. Here's how to fix the problem with a standard deviation calculation.

How to Foot and Cross-Foot Excel Reports in a Floating-Point World

At first glance, the following report is an ordinary one. It merely sums an Excel Table by Product and Region, and then foots and...

Excel’s XLOOKUP Function Explained

Excel's XLOOKUP function searches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't...

Excel’s VLOOKUP Function Explained

Excel's VLOOKUP function looks in the first column of an array and moves across the row to return the value of a cell. VLOOKUP is...
Advertisement
Advertisement