Wednesday, May 31, 2023
Home Excel Methods Charting Methods

Charting Methods

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

    Random
    Each fat line in this chart indicates when a recession has occured for the specified country. You can use the same method to show other Boolean conditions.

    Chart Recessions and Other Boolean Conditions in Excel

    Charting Methods Charley Kyd -
    0
    I doubt you’ve seen an Excel chart like this before. It shows multiple Boolean conditions that might affect the trend in the annual Rate...
    Although Excel's FREQUENCY function was designed to calculate frequency distributions, you also can use the SUM-IF, SUMPRODUCT, INDEX-FREQUENCY, and COUNTIFS functions. Here's a summary of the methods and your options.

    Five Ways to Calculate Frequency Distributions in Excel

    Charting Methods Charley Kyd -
    0
    Walt captures blood-pressure readings and wants to find how often the readings fall into various ranges of values. This is a common need for a...
    Three More Simple Tricks to Improve Excel Charts for Business

    Three More Simple Tricks to Improve Excel Charts for Business

    Charting Methods Charley Kyd -
    0
    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...
    The two Excel dashboard-like charts with May data show that consumer confidence has dropped like a rock since March. But Asia's data isn't available yet.

    Dashboard-Like Excel Charts of International Consumer Confidence

    Charting Methods Charley Kyd -
    0
    The following Excel figure displays its charts in a dashboard-like format. At least, it's in a format that dashboards should use! When you use simple...
    Top-ten figures are useful because managers need to know where the greatest opportunities and the worst problems are. Here are ideas to make them readable.

    How to Make Top-Ten Charts Easier to Read

    Charting Methods Charley Kyd -
    0
    Managers need to know where the greatest opportunities and the worst problems can be found. This is why top-item figures are so popular. These figures...
    Using the right Excel charts to display year-to-date variances can clarify budgets and spending problems. But using the wrong charts is a waste of time.

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

    Charting Methods Charley Kyd -
    0
    Many companies have a difficult time creating charts of spending variances. In fact, many companies rely on charts that are nearly useless for that...
    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...
    The word "funnels" is a widely used business term, but Funnel Charts aren't. Here's how and why to set up a Funnel Chart in Excel.

    How to Create Funnel Charts in Excel

    Charting Methods Charley Kyd -
    0
    Although “funnels” are a common term in selling, the concept also can apply to other business activities. The general idea is that an organization begins...
    When you include several charts in one report, your managers must THINK about each chart to decide if it shows good news or bad. Here's a fix for that.

    How to Remove a Speed Bump From Your Excel Charts

    Charting Methods Charley Kyd -
    0
    Because managers need QUICK insight, we should remove as many speed bumps as possible from our reports and analyses. The following figure with two Excel...
    Use these little-known Excel charting tricks in your management reports to compare many categories of your business performance...clearly.

    Compare Metrics by Category Using Excel Dot Plot Charts

    Charting Methods Charley Kyd -
    0
    Management reports often must compare measures of performance by some type of category. For example, reports could compare sales by product, variance by department, sales...
    123...6Page 1 of 6

    Latest Articles

    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...
    Two economists have introduced a new leading indicator, which predicts a recession soon. These Excel charts illustrate their insight. If they're correct, Excel users will be very busy in the months ahead.

    Consumer Sentiment Suggests a 2022 Recession

    Charting Methods Charley Kyd -
    0
    In recent months, business websites have speculated about recessions and stagflation in 2022. These predictions could affect your Excel work significantly in the next few...
    Advertisement
    © ExcelUser, Inc. Copyright © 2004 - 2020 by Charles W. Kyd, all rights reserved.