+ Reply to Thread
Results 1 to 4 of 4

Excel Chart-Remove Outliers Issue-Unorthodox Approach

  1. #1
    Registered User
    Join Date
    10-23-2018
    Location
    New York
    MS-Off Ver
    10
    Posts
    22

    Excel Chart-Remove Outliers Issue-Unorthodox Approach

    I have a customer who doesn't like the look of the outliers in a bar chart. For instance, one has 100 total, and the remainder average 5. I personally don't like messing with this, but they want it to look different. The answer is either really obvious, or has data integrity issues. Below is an example of what I am talking about.

    Average score is 5. Outlier is 100. If I change the chart range to 10, it looks weird even if I apply the 100 score next to the outlier. Are there any real good options here outside of simply changing the chart range because that to me looks ridiculous.

    PS-Removing the outliers isn't an option to the customer. It has to be there somewhere in the chart.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    7,684

    Re: Excel Chart-Remove Outliers Issue-Unorthodox Approach

    Sounds as if you may be looking for a "broken" bar chart as discussed in the linked article below.
    https://alesandrab.wordpress.com/201...nd-bar-charts/
    Note that you have to scroll to the bottom of the article to see the method applied to a bar chart.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    11,174

    Re: Excel Chart-Remove Outliers Issue-Unorthodox Approach

    Jon Peltier, a charting blogger I follow, does not like broken axis charts -- though you can certainly choose to use one if you like. He recommends a panel chart instead: https://peltiertech.com/broken-y-axis-in-excel-chart/ In your situation, a panel chart may be a good option. One panel readily shows the full data set and how the outlier(s) are very different from the rest of the data, and the second panel shows the main data.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  4. #4
    Registered User
    Join Date
    10-23-2018
    Location
    New York
    MS-Off Ver
    10
    Posts
    22

    Re: Excel Chart-Remove Outliers Issue-Unorthodox Approach

    I will look at both of your options and make a choice. thanks so much to both of you!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1