ExcelUser logo Free guides and templates
Work In Progress...After nearly ten years, I'm redesigning ExcelUser.com. This is the new design. You can learn more here. Also, if you find something wrong with the site, please tell me about the problems. And thanks for your patience.--Charley Kyd
Home > 

ExcelUser Site Map

Home  

ExcelUser Home Page

About  

About Charley Kyd

About  

Become an ExcelUser Affiliate

About  

We're Undergoing Massive Changes! Here's the Story...

About  

ExcelUser -- Michael Gonnerman

About  

About ExcelUser.com

About  

ExcelUser -- Marty Ryerson

About  

Testimonials from Users of Our Excel Templates, Add-Ins, and Training

About  

Excel Users in Most of the World Use Our Dashboard Reports

About  

The World's 10 Largest Companies in 2008 All Use Kyd Dashboard Reports

About  

Examples of the Countries Where Our Excel Dashboards Are Used

About  

Kyd Excel Dashboard Users in United Arab Emirates

About  

Kyd Excel Dashboard Users in Australia

About  

Kyd Excel Dashboard Users in Belgium

About  

Kyd Excel Dashboard Users in Brazil

About  

Kyd Excel Dashboard Users in Canada

About  

Kyd Excel Dashboard Users in Switzerland

About  

Kyd Excel Dashboard Users in Germany

About  

Kyd Excel Dashboard Users in Denmark

About  

Kyd Excel Dashboard Users in Spain

About  

Kyd Excel Dashboard Users in France

About  

Kyd Excel Dashboard Users in Hong Kong

About  

Kyd Excel Dashboard Users in Ireland

About  

Kyd Excel Dashboard Users in India

About  

Kyd Excel Dashboard Users in Italy

About  

Kyd Excel Dashboard Users in Mexico

About  

Kyd Excel Dashboard Users in Malaysia

About  

Kyd Excel Dashboard Users in The Netherlands

About  

Kyd Excel Dashboard Users in New Zealand

About  

Kyd Excel Dashboard Users in Philippines

About  

Kyd Excel Dashboard Users in Sweden

About  

Kyd Excel Dashboard Users in Singapore

About  

Kyd Excel Dashboard Users in United Kingdom

About  

Kyd Excel Dashboard Users in the Dow-30 Companies in the United States

About  

Kyd Excel Dashboard Users in South Africa

About  

Kyd Excel Dashboard Users by Industry

About  

Police and Military Organizations Using Kyd Dashboard Reporting for Excel

About  

US Cities Using Kyd Dashboard Reporting for Excel

About  

US Counties Using Kyd's Excel Dashboard Reports

About  

US Federal Agencies Using Kyd's Excel Dashboard Reports

About  

US States Using Kyd's Excel Dashboard Reports

About  

Large Companies in Basic Industries That Use Kyd's Excel Dashboard Reports

About  

Large Capital-Goods Companies Using Kyd's Excel Dashboard Reports

About  

Conglomerates Using Kyd's Excel Dashboard Reports

About  

Large Consumer-Cyclical Companies Using Kyd's Excel Dashboard Reports

About  

Large Consumer-Non-Cyclical Companies Using Kyd's Excel Dashboard Reports

About  

Large Energy Companies Using Kyd's Excel Dashboard Reports

About  

Banks Around the World Using Kyd's Excel Dashboard Reports

About  

Large Financial Companies Using Kyd's Excel Dashboard Reports

About  

Drug, Equipment, and Other Healthcare Companies Using Kyd's Excel Dashboard Reports

About  

Hospitals That Track Performance Using Kyd's Excel Dashboard Reports

About  

Large Business Services Using Kyd's Excel Dashboard Reports

About  

Large Communication Companies Using Kyd's Excel Dashboard Reports

About  

Printing and Publishing Services Using Kyd's Excel Dashboard Reports

About  

Large Retail Companies Using Kyd's Excel Dashboard Reports

About  

Web & Entertainment Services Using Kyd's Excel Dashboard Reports

About  

Large Technology Companies Using Kyd's Excel Dashboard Reports

About  

Large Transportation Companies Using Kyd's Excel Dashboard Reports

About  

Large Utility Companies Using Kyd's Excel Dashboard Reports

About  

Foundations and Charities Using Kyd's Excel Dashboard Reports

About  

Colleges and Universities Using Kyd's Excel Dashboard Reports

Downloads  

Free Downloads & Updates

Excel Dashboards  

How to Add Web Data to Your Excel Dashboard Reports

Excel Dashboards  

Display Any Colors in Excel 97-2003

Excel Dashboards  

When Should Large Firms Use Both 'Real' AND Excel Dashboard Reports?

Excel Dashboards  

Map Costs and Sales in Excel with This Breakeven Chart

Excel Dashboards  

How to Create Bullet Graphs to Replace Gauges in Excel

Excel Dashboards  

Learn to Show Business Data That Readers Can Understand

Excel Dashboards  

Use Common-Age Excel Charts to Compare Performance for the Same Number of Periods After a Launch

Excel Dashboards  

Create Cycle Plots in Excel to Chart Seasonal Sales Data

Excel Dashboards  

Create Cycle Plots in Excel to Chart Seasonal Sales Data

Excel Dashboards  

Dashboard Gauges Are Still a Terrible Idea!

Excel Dashboards  

Do Excel Dashboards or Normal Reports Offer More Business Insight?

Excel Dashboards  

Seven Ways Excel Dashboards Can Improve Cash Flows

Excel Dashboards  

Compare Metrics by Category Using Excel Dot Plot Charts

Excel Dashboards  

DuPont Chart from Excel

Excel Dashboards  

Map Your Financial Health With an Excel DuPont Dashboard

Excel Dashboards  

How to Create Excel Traffic Lights with Charts and Text

Excel Dashboards  

Explore Business Performance Using Small Charts in Excel

Excel Dashboards  

The First Excel Dashboard Report Ever Created

Excel Dashboards  

The First Excel Dashboard Report Shown in Public

Excel Dashboards  

An Excel Dashboard Report from 1992 with Financial Data for a Public Company

Excel Dashboards  

The First Excel Dashboard Report, Created by Charley Kyd in 1990

Excel Dashboards  

Excel Dashboard Report Showing Public Financial Data, from 1992

Excel Dashboards  

Dashboard Reports Before Excel: Mini-Graph Reports in Lotus 1-2-3

Excel Dashboards  

The First Public Example of an Excel Dashboard Report

Excel Dashboards  

Down With Gauges

Excel Dashboards  

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

Excel Dashboards  

How to Create Dynamic Chart Legends in Excel

Excel Dashboards  

How to Help Readers Interpret Chart Trends Correctly...Three Tips in One

Excel Dashboards  

Excel Charts, Dashboards, & Visualization Tools

Excel Dashboards  

Introducing Excel Dashboards for Management Reporting

Excel Dashboards  

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

Excel Dashboards  

Will the New Kindle DX Transform Management Reporting With Excel?

Excel Dashboards  

How to Create Normal Chart Curves In Excel, With Shaded Areas

Excel Dashboards  

How to Create Normal Chart Curves In Excel, With Shaded Areas

Excel Dashboards  

Ten Examples of Pablum Dashboards for Managers

Excel Dashboards  

Derivation of the Formula For Planning Price Changes

Excel Dashboards  

Should You Raise Prices? Should You Lower Them? This Excel Chart Can Help You Answer That Question.

Excel Dashboards  

Excel Chart of Recessions by Country, Using Conditional Formats and Formulas

Excel Dashboards  

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

Excel Dashboards  

How to Analyze Seasonal Sales in Excel

Excel Dashboards  

How to Get Started with Excel Dashboard Reporting

Excel Dashboards  

Spark Urgency to Improve Performance by Using Excel Dashboards

Excel Dashboards  

US Economic Overview Excel Dashboard

Excel Dashboards  

Show Useful Year-to-Date Variance Charts in Your Excel Dashboards

Excel Dashboards  

Sample Excel Dashboard Reports

Excel Dashboards  

Dashboards for Excel: Hospital Ambulatory Care Sensitive Conditions

Excel Dashboards  

A Hospital Administrator Shows How Excel Dashboards Improve Outcomes

Excel Dashboards  

Dashboard Reports for Excel: An Example of Hospital Turnarounds

Excel Dashboards  

Financial Excel Dashboards: Dow Jones & McGraw-Hill

Excel Dashboards  

Financial Excel Dashboards: Microsoft & Starbucks

Excel Dashboards  

IncSight Medley: Excel Dashboards with Charts and Comments

Excel Dashboards  

A Monthly Financial Dashboard that Combines Standard Tables & Charts

Excel Dashboards  

A Repeating-Detail Dashboard to Compare Multiple Entities

Excel Dashboards  

Repeating-Detail Dashboard that Mostly Relies on Tables

Excel Dashboards  

Sales Force Marketing & Analytics Reports as Excel Dashboards

Excel Dashboards  

Sample Excel Dashboard Reports from Forbes and Business Week

Excel Dashboards  

Sample Excel Dashboard Reports from the IncSight DB2 Templates

Excel Dashboards  

Sample Excel Dashboard Reports from the IncSight QnE2 Templates

Excel Dashboards  

The Stamp-Report Dashboard Displays 110 Excel Charts on One Page

Excel Dashboards  

US Economic-Overview Excel Dashboard for Managers, Saved as a Bitmap in Full Size

Excel Dashboards  

Wire-Frame Excel Dashboard that Follows Edward Tufte's Advice

Excel Dashboards  

Sales Reports Presented Using Excel Dashboard Reports

Excel Help  

Excel MVPs: Their Known Excel Books and Web Sites

Excel Help  

Known Web Sites of Current and Former Excel MVPs

Excel Help  

Excel Help Portal

Excel Help  

Excel Shortcut Keys Offer Quick Access to Dialogs

Excel Help  

ABS Function

Excel Help  

ADDRESS Function

Excel Help  

AGGREGATE Function

Excel Help  

AND Function

Excel Help  

AVERAGE Function

Excel Help  

AVERAGEA Function

Excel Help  

AVERAGEIF Function

Excel Help  

AVERAGEIFS Function

Excel Help  

CEILING.MATH Function

Excel Help  

CEILING.PRECISE Function

Excel Help  

CEILING Function

Excel Help  

CHAR Function

Excel Help  

CHOOSE Function

Excel Help  

CLEAN Function

Excel Help  

CODE Function

Excel Help  

COLUMN Function

Excel Help  

COLUMNS Function

Excel Help  

COUNT Function

Excel Help  

COUNTA Function

Excel Help  

COUNTBLANK Function

Excel Help  

COUNTIF Function

Excel Help  

COUNTIFS Function

Excel Help  

DATE Function

Excel Help  

DATEVALUE function

Excel Help  

DAY Function

Excel Help  

MODE Function

Excel Help  

MODE Function

Excel Help  

EDATE Function

Excel Help  

EOMONTH Function

Excel Help  

ROUNDUP Function

Excel Help  

FALSE function

Excel Help  

FIND Function

Excel Help  

ROUNDUP Function

Excel Help  

FLOOR.PRECISE Function

Excel Help  

FLOOR Function

Excel Help  

FREQUENCY Function

Excel Help  

FV Function

Excel Help  

GETPIVOTDATA Function

Excel Help  

GROWTH Function

Excel Help  

HLOOKUP Function

Excel Help  

HOUR Function

Excel Help  

IF Function

Excel Help  

IFERROR Function

Excel Help  

INDEX Function

Excel Help  

INDIRECT Function

Excel Help  

INT Function

Excel Help  

IPMT Function

Excel Help  

IRR Function

Excel Help  

ISERR Function

Excel Help  

ISNA Function

Excel Help  

ISO.CEILING Function

Excel Help  

ISOWEEKNUM Function

Excel Help  

LARGE Function

Excel Help  

LEFT Function

Excel Help  

LEN Function

Excel Help  

LINEST Function

Excel Help  

LOGEST Function

Excel Help  

LOOKUP Function

Excel Help  

LOWER Function

Excel Help  

MATCH Function

Excel Help  

MAX Function

Excel Help  

MEDIAN Function

Excel Help  

MID Function

Excel Help  

MIN Function

Excel Help  

MINUTE Function

Excel Help  

MIRR Function

Excel Help  

MMULT Function

Excel Help  

MOD Function

Excel Help  

MODE.SNGL Function

Excel Help  

MODE Function

Excel Help  

MONTH Function

Excel Help  

MROUND Function

Excel Help  

N Function

Excel Help  

NA Function

Excel Help  

NETWORKDAYS.INTL Function

Excel Help  

NETWORKDAYS Function

Excel Help  

NORM.DIST Function

Excel Help  

NORM.INV Function

Excel Help  

NORMINV Function

Excel Help  

NOT Function

Excel Help  

NOW Function

Excel Help  

NPER Function

Excel Help  

NPV Function

Excel Help  

ODD Function

Excel Help  

OFFSET Function

Excel Help  

OR Function

Excel Help  

PERCENTILE.EXC function

Excel Help  

PERCENTILE.INC Function

Excel Help  

PERCENTILE Function

Excel Help  

PERCENTILE Function

Excel Help  

PERCENTILE Function

Excel Help  

PERCENTILE Function

Excel Help  

PMT Function

Excel Help  

PPMT Function

Excel Help  

PRODUCT Function

Excel Help  

PROPER Function

Excel Help  

PV Function

Excel Help  

QUARTILE.EXC function

Excel Help  

QUARTILE.INC Function

Excel Help  

QUARTILE Function

Excel Help  

RAND Function

Excel Help  

RANDBETWEEN Function

Excel Help  

RANK Function

Excel Help  

RANK Function

Excel Help  

RANK Function

Excel Help  

RATE Function

Excel Help  

REPLACE Function

Excel Help  

RIGHT Function

Excel Help  

ROUND Function

Excel Help  

ROUNDDOWN Function

Excel Help  

ROUNDUP Function

Excel Help  

ROW Function

Excel Help  

ROWS Function

Excel Help  

SEARCH Function

Excel Help  

SECOND Function

Excel Help  

SIGN Function

Excel Help  

SMALL Function

Excel Help  

STDEV.P Function

Excel Help  

STDEV.S Function

Excel Help  

STDEV Function

Excel Help  

STDEVP Function

Excel Help  

STEYX Function

Excel Help  

SUBSTITUTE Function

Excel Help  

SUBTOTAL Function

Excel Help  

SUM Function

Excel Help  

SUMIF Function

Excel Help  

SUMIFS Function

Excel Help  

SUMPRODUCT Function

Excel Help  

T Function

Excel Help  

TEXT Function

Excel Help  

TIME Function

Excel Help  

TIMEVALUE Function

Excel Help  

TODAY Function

Excel Help  

TRANSPOSE Function

Excel Help  

TREND function

Excel Help  

TRIM Function

Excel Help  

TRIMMEAN Function

Excel Help  

TRUE Function

Excel Help  

TRUNC Function

Excel Help  

CODE Function

Excel Help  

CODE Function

Excel Help  

UPPER Function

Excel Help  

VALUE Function

Excel Help  

VAR.P Function

Excel Help  

VAR.S function

Excel Help  

VLOOKUP Function

Excel Help  

WEEKDAY Function

Excel Help  

WEEKNUM Function

Excel Help  

WORKDAY.INTL Function

Excel Help  

WORKDAY Function

Excel Help  

YEAR Function

Excel Help  

YEARFRAC Function

Excel Help  

What's a 'Deprecated' Function?

Excel Help  

Guide to Using Wildcards in Excel Worksheet Functions

Excel Help  

All Excel Worksheet Functions, with Links to Help Topics

Excel Help  

Guide to Excel's Date Functions

Excel Help  

Overview of Excel's Rounding Functions

Excel Help  

Subscribe to 'Excel for Business'

Excel Help  

Using Absolute and Relative References in Excel Formulas

Excel Help  

How to Add Background Images in Excel

Excel Help  

Two Ways to Wrap Excel Text

Excel Help  

Using Absolute and Relative Cell References in Excel Formulas

Excel Help  

How to Use Conditional-Format Formulas to Change Background Colors

Excel Help  

How to Count the Items that Occur a Certain Number of Times in a List

Excel Help  

Consolidating Excel Data From Many Workbooks

Excel Help  

Debugging Excel's INDEX Function

Excel Help  

Use VBA Functions to Return Excel Document Properties

Excel Help  

Find Duplicates in Excel Lists

Excel Help  

Questions About Excel

Excel Help  

Convert All Entries in a Range in Excel To Lower-Case Text

Excel Help  

How to Define Excel Range Names with a Worksheet Scope

Excel Help  

Changing Types and Axes in Microsoft Excel Charts

Excel Help  

Use a Combo Box with Many Criteria in an Excel Database

Excel Help  

Resetting the Used Range of a Scroll Box

Excel Help  

Rounding Values Up in Excel Using Excel's CEILING and INT Functions

Excel Help  

Rounding Values Up in Excel

Excel Help  

How to Tab From Cell to Cell in an Excel Worksheet Form

Excel Help  

Track Dynamic Data with VBA Or with Iterative Calculations

Excel Help  

Look Up Key Data with an Excel Dropdown List Box

Excel Help  

Read a Text File with VBA, And Write the Text to Excel

Excel Help  

Weekly Dashboard Reporting with Excel

Formulas  

How to Add Advanced Filter Capabilities to Excel Tables

Formulas  

Add Class to Your Reports with Excel Drawing Objects

Formulas  

Summarize Spreadsheet Data With Excel's Array Formulas

Formulas  

Seven Ways to Avoid Errors In Excel Reports and Analyses

Formulas  

Document Excel Worksheets with Pictures that Include Row and Column Headings

Formulas  

Use COUNTIFS, not FREQUENCY, to Calculate Frequency Distribution Tables for Charting Histograms

Formulas  

Excel Spreadsheet Functions That Read Values From Cubes

Formulas  

Use Excel's Data Validation Feature to Return Items from a List

Formulas  

How to Create and Use Dynamic Range Names in Excel

Formulas  

How to Work With Dates Before 1900 in Excel

Formulas  

Three Ways to Reduce Errors in Your Excel SUM Formulas

Formulas  

Introducing the Power of Excel Range Names

Formulas  

Excel’s VLOOKUP vs INDEX-MATCH Functions

Formulas  

Five Really Useful Excel Keyboard Shortcuts

Formulas  

How to Calculate Frequency Distributions in Excel

Formulas  

How to Fight Spreadsheet Hell with Three Excel Lookup Functions

Formulas  

How to Set Up a Pivot Table as a Spreadsheet Database

Formulas  

How to Use SUMPRODUCT to Create Two-Dimensional Lookups in Excel Formulas

Formulas  

Excel Formulas, Data, Tables, & VBA

Formulas  

Introducing Excel’s Three Types of Spreadsheet Databases

Formulas  

How Excel's MIRR Function Can Fix the IRR Function

Formulas  

Use SUMPRODUCT to Find The Last Item in an Excel List

Formulas  

Use MS Query to Treat Excel as a Relational Data Source

Formulas  

Use MS Query with Text Files for Dynamic Excel Reporting

Formulas  

How to Perform Multiple Searches Using One SEARCH Function in Excel

Formulas  

How to Report Periodic Data from Excel Databases

Formulas  

How to Round Time in Excel to Any Increment

Formulas  

How to Use Excel's Better-Known Rounding Functions: INT, ROUNDUP, ROUNDDOWN, & ROUND

Formulas  

Use SUMPRODUCT in an Excel Table to Filter Any Number of Items

Formulas  

An Introduction to Excel's Normal Distribution Functions

Formulas  

How to Summarize Data for Reporting and Analysis in Excel 2003

Formulas  

The Most Powerful Ways to Summarize Excel Data for Reporting and Analysis

Formulas  

Use SUMPRODUCT in Excel 97-2003 to Summarize Worksheet Data

Formulas  

Use Excel's SUMPRODUCT to Summarize Worksheet Data

Formulas  

How to Use Excel Formulas to Calculate a Term-Loan Amortization Schedule

Formulas  

Introducing Excel’s Three Types of Spreadsheet Databases

Formulas  

The Two Functions You MUST Know to Return Values from Excel Tables and Databases

Formulas  

Corporate VBA Standards for Excel Users Who Program

Formulas  

Use Excel 2003's Web Queries to View Web Data Easily

Formulas  

Use Excel's Web QueriesTo Easily View Web Data

Formulas  

What the heck is an Excel database?

Formulas  

Why INDEX-MATCH Is Far Better Than VLOOKUP or HLOOKUP in Excel

Formulas  

Find Future and Present Values From Scheduled Cash Flows In Excel

Ideas  

Use Benford's Law with Excel 97-2003 to Improve Business Planning

Ideas  

Use Benford's Law with Excel to Improve Business Planning

Ideas  

Control Your Cost Lag Loop To Help Survive the Recession

Ideas  

Weighing Your Debt Load

Ideas  

Does This Reporting Strategy Make Any Sense to You?

Ideas  

Drucker's Advice for CEOs Can Bring Spreadsheet Hell -- An article about Excel.

Ideas  

Use Excel's Drawing Tools to Create Your Own Cartoons

Ideas  

Five Reasons Excel BI Is Key To Your Company's Success

Ideas  

Excel Makes a Great BI!

Ideas  

Excel Shows Why Low Tax Rates Increase Government Receipts

Ideas  

The Partnership of OLAP and Excel Brings A Cure for Spreadsheet Hell

Ideas  

How Fast Is Too Fast?

Ideas  

Ideas for Business and Excel

Ideas  

Bain's Management Tools -- An article about Excel.

Ideas  

Metric Madness? -- An article about Excel.

Ideas  

Use Excel's Unique Power To Raise Manager Alerts

Ideas  

Is Excel Budgeting a Mistake?

Ideas  

The Excel 2007 User Interface, An Excel 2007 Reference

Ideas  

Five Reasons OLAP Belongs On Excel Users' Desktops

Ideas  

What the Heck Is OLAP? When Is It Excel-Friendly?

Ideas  

Use Business Tools With Excel To Save Time and Money

Ideas  

What Do Users Need From Excel-Friendly Data Sources?

Ideas  

BI Products for Excel

Ideas  

Hands-On Video: Budgeting and Forecasting With Excel and PowerOLAP

Ideas  

Created by Camtasia Studio 4

Ideas  

Hands-On Video: Using PowerOLAP & Excel With Charts and Dashboards

Ideas  

Created by Camtasia Studio 4

Ideas  

Hands-On Video: Introduction to Using PowerOLAP with Excel

Ideas  

Created by Camtasia Studio 4

Legal  

Disclaimer

Legal  

Earnings and Income Disclaimers

Legal  

Excel User - Copyright Information

Legal  

Privacy Policy

Legal  

Reprint Policy

Legal  

Terms of Use for Website and Products

Partners  

ExcelUser Affiliate Ads

Partners  

Sell ExcelUser E-Books, Workbooks, Templates, & Training

Reports  

Create Variable-Length, Dynamic Reports Linked to Excel Tables

Reports  

Use Excel to Fix Your Broken AR Measure: Days Sales Outstanding in Receivables (DSO)

Reports  

Thirteen Ways to Improve Your Monthly Board Reports with the Help of Excel

Reports  

Example of an Excel Cash Calendar for Managing Periodic Payments

Reports  

Manage Periodic Payments with an Excel Cash Calendar

Reports  

Use Conditional Formatting to Manage Customer Tasks

Reports  

Strategies for an Excel System For Invoicing or Estimating

Reports  

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

Reports  

Excel Reporting and Financial Topics

Reports  

Use Excel's INDEX-MATCH or VLOOKUP Functions to Populate Invoices and POs

Reports  

Show Key Stats Automatically in Periodic Excel Reports

Reports  

Add Cash Flow Information to Your Excel Balance Sheets

Reports  

Use this Excel 'Cash Flow Balance Sheet' to See Sources & Uses of Funds Between Two Periods

Reports  

Using Excel to Find Errors After a System Conversion

Reports  

Excel Can Help You Find The Variances That Matter

Reports  

Predict Business Bankruptcy Using Z Scores with Excel

Training  

Excel Training & Templates

Training  

Excel Add-Ins for Charts Can Do the 'Impossible'

Training  

Use Worksheet Formulas to Return Business Data from the Web

Training  

Charley's Swipe File Chart Figures, Page 2

Training  

Charley's Swipe File Chart Figures, Page 1

Training  

Charley's Swipe File #1...A Chart Figure with Blocks of Text

Training  

Charley's Swipe File #2...An Excel Chart with Rounded Corners

Training  

Charley's Swipe File #3...An Excel area chart with a top border

Training  

Charley's Swipe File #4...An Excel 'small-multiples', or 'trellis display', or 'panel chart.'

Training  

Charley's Swipe File #5...A Excel stacked column chart with an unusual border format, with text.

Training  

Charley's Swipe File #6...A Two-Chart Figure for Profesional Reports

Training  

Charley's Swipe File #7...Table with Great Formatting

Training  

Charley's Swipe File #8...A Distinctive Semi-Transparent Excel Chart

Training  

Charley's Swipe File #9...A Professional Mini-Dashboard Panel Chart Figure

Training  

Charley's Swipe File #10...Bar Chart Comparing Two Entities Over Time

Training  

Charley's Swipe File #11...Excel Mini-Dashboard

Training  

Charley's Swipe File #12...Bar Chart with Justified Titles

Training  

Charley's Swipe File #13...Excel Dot-Plot and Table

Training  

Charley's Swipe File #14...Excel Dot-Plot from 'The Economist' Magazine

Training  

Charley's Swipe File #15x...Excel Area Charts from 'The Economist' Magazine

Training  

Charley's Swipe File #16...Dual Excel Column Charts to Compare Performance Measures

Training  

Charley's Swipe File #17...Excel Bullet Charts in a Table

Training  

Charley's Swipe File #18...Two Column Mini-Charts in Excel

Training  

Charley's Swipe File #19...Connected Dot Plot Chart from Excel

Training  

Charley's Swipe File #20...Dual-Color Column and Area Charts in Excel

Training  

Charley's Swipe File #21...Excel Dashboard with Line Charts, Area Charts, Column Charts, and Bar Charts

Training  

Charley's Swipe File #22...Distinctive Bar Chart from the Wall Street Journal

Training  

Charley's Swipe File #23...Excel Bar Chart for Displaying Ranked Data

Training  

Charley's Swipe File #24...Line Chart with Legends that Contain Numbers and Text

Training  

Charley's Swipe File #25...Excel Chart with Four Distinct Sets of Columns

Training  

Charley's Swipe File #26...Excel Line Chart that Sorts and Ranks Data Automatically

Training  

Charley's Swipe File #27...Unusual Column Chart that Compares Two Measures

Training  

Charley's Swipe File #28...Excel Line Chart with a Call-Out Showing Greater Detail

Training  

Charley's Swipe File #29...Excel Line Chart with Shaded Areas Showing Recessions in Four Regions

Training  

Charley's Swipe File #30...Excel 'Rainbow Charts' or 'Calc Plots' to Display Three Axes of Information

Training  

Charley's Swipe File #31...Excel Dot-Plot Chart Showing Percentage Performance by Category

Training  

Charley's Swipe File #32...Excel Column Chart Showing Banded Peformance by Year

Training  

Charley's Swipe File #33...Line Chart that Links Specific Points to Accompanying Data

Training  

Charley's Swipe File #34...Excel Charts with Legends that Automatically Sort by Ending Values

Training  

Charley's Swipe File #35...Line Chart with Enhanced Legends from the Wall Street Journal

Training  

Charley's Swipe File #36...Profit-Loss Excel Chart with Dots and Columns

Training  

Charley's Swipe File #37...Excel Chart that Links Two Columns of Ranked Data

Training  

Charley's Swipe File #38...Dual-Width Column Charts from the Wall Street Journal

Training  

Charley's Swipe File #39...Line Chart with Legends that Display Comments About the Data

Training  

Charley's Swipe File #40...Great-Looking Dual-Width Column Charts in Excel

Training  

Charley's Swipe File #41...A Boolean Chart Created in a Spreadsheet

Training  

Charley's Swipe File #42...Column Charts Automatically Showing Best and Worst Results

Training  

Charley's Swipe File #43...Split Trend Lines Making Changes in Peformance Obvious

Training  

Charley's Swipe File #44...Line Charts Showing Year-Over-Year Performance to Reveal Hidden Trends

Training  

Charley's Swipe File #45...An Excel 'Swarm' Chart Putting Current the Trend in Context

Training  

Charley's Swipe File #46...Line Chart with Arrows that Show Major Changes in Performance

Training  

Charley's Swipe File #47...Line Chart with Recession Indicators

Training  

Charley's Swipe File #48...Line Chart with Bands of Past Ranges and Median Performance

Training  

Charley's Swipe File #49...Line and Column Chart with Using Multiple Tricks

Training  

Charley's Swipe File #50...Traffic-Light Chart with Alerts Using Excel's Camera Tool

Training  

Charley's Swipe File #51...A Two-Line Macro Offers Five Designs for this Chart

Training  

Charley's Swipe File #52...Candle Stick Chart with More Power than Excel's Built-In Version

Training  

Charley's Swipe File #53...Line Chart Showing the Range of Past Performance

Training  

Charley's Swipe File #54...Three Charts to Replace Pie Charts

Training  

Charley's Swipe File #55...Stacked Columns with Enhanced Legends

Training  

Charley's Swipe File #56...This Target Chart Is Cool But Probably Serves No Purpose

Training  

Charley's Swipe File #57...Stacked Column Chart with Distinctive Formatting and Values

Training  

Charley's Swipe File #58...Bar Chart with Dual Frequency Distributions

Training  

Charley's Swipe File #59...Grouped Column Plots with Custom Headers

Training  

Charley's Swipe File #60...Grouped Column Charts with Distinctive Shading

Training  

Charley's Swipe File #61...Excel Breakeven Chart to Monitor Performance

Training  

Charley's Swipe File #62...Stephen Few's Bullet Charts

Training  

Charley's Swipe File #63...The Excel Three-Dot Scorecard

Training  

Charley's Swipe File #64...An Improvement on Excel Stacked Column Charts

Training  

Charley's Swipe File #65...Small multiple Excel charts with reference lines

Training  

Charley's Swipe File #66...Chart comparing actual performance to forecasts

Training  

Charley's Swipe File #67...Chart comparing three time-series plots.

Training  

Charley's Swipe File #68...Three-Chart Figure with This Year and Last Year

Training  

Charley's Swipe File #69...Four-Chart Figure with Quarterly and Daily Data

Training  

Charley's Swipe File #70...Excel Alert Using a Standard Error

Training  

Charley's Swipe File #71...DuPont Dashboard

Training  

Charley's Swipe File #72...Winners and Losers Chart

Training  

Give Your Managers More Insight, More Quickly, Using Less Time and Money

Training  

The Excel Experimental Laboratory

Training  

Subscribe to Charley's Swipe Files

Training  

Custom Office Color Themes

Training  

How to Quickly Create & Update Professional Dashboard Reports in Excel 2007 & Above

Training  

Deliver This Financial-Statement Excel Dashboard to Your VIPs...By Tomorrow!

Training  

Excel Dashboard Templates with Dynamic Text & Multiple Filters

Training  

IncSight DB2: Here’s How to WOW! Your Boss And Save Hours of Work Each Month







Charley's SwipeFile charts


Dashboard Reporting With Excel