Monday, September 29, 2025
Linkedin
Linkedin
Home Excel Methods Charting Methods Page 6

Charting Methods

    All about creating, using, setting up, and improving Excel charts.

    Latest
    Beginning in Excel 2016 in Office 365, your formulas can set gaps in your line and scatter charts. Here are two ways to use the feature in your reports.

    Two Business Uses for Excel’s New Chart Feature

    Charting Methods Charley Kyd - 0
    For decades, I've been whining about the need for Excel to have some way for our formulas to specify a gap in line and...
    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

    Charting Methods Charley Kyd - 0
    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...
    By charting the annual Rate Of Change (ROC) of key measures, you can uncover significant information about your time-series data. And by using the right recession measure, you can put that information into better context.

    Chart Your Rate of Change to Reveal Hidden Business Performance

    Charting Methods Charley Kyd - 0
    What insights can you gain from the following Excel chart of Apple's quarterly revenues over the past 18 years? I see three things. First, their...
    Excel provides several worksheet functions for working with normal distributions or 'bell-shaped curves.' This introduction to Excel's Normal Distribution functions offers help for the statistically challenged.

    An Introduction to Excel’s Normal Distribution Functions

    Charting Methods Charley Kyd - 0
    (Download the workbook.) When a visitor asked me how to generate a random number from a Normal distribution she set me to thinking about doing statistics...
    Using Excel 2007 and above, you can create shaded areas in charts to specify areas of special interest. Here's how to do this using normal curves.

    How to Create Normal Curves With Shaded Areas in Excel

    Charting Methods Charley Kyd - 0
    Adding shaded areas to normal curves like this is a challenging task in Excel charting. But once you know how, it's not difficult to...
    On Valentine's Day, 2018, tens of thousands of major sites warned their readers that inflation is rising. But that might not be true. These analytical Excel charts suggest a different conclusion.

    What Inflation? How Excel Charts Can Help You Avoid Fake Economic News

    Charting Methods Charley Kyd - 0
    The business news on Valentine's Day, 2018, was dominated by talk of rising inflation. A search of Google News showed 67,100 results for the...
    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

    Charting Methods Charley Kyd - 0
    With normal charts, you find data and then you plot it. But with analytical charts, you transform your data in various ways to discover...

    Latest Articles

    Excel Flowbook Revolution

    Getting Radical with Excel

    Excel Data Plumbing Revolution Charley Kyd - 0
    It's time to think about Excel in a radical new way—when we use it to work with business or economic data. It's time, in fact,...
    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?

    Accounting & Finance Charley Kyd - 0
    (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

    Charting Methods Charley Kyd - 0
    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...
    Advertisement
    © ExcelUser, Inc. Copyright © 2004 - 2020 by Charles W. Kyd, all rights reserved.