+ Reply to Thread
Results 1 to 3 of 3

Plotting outlier in Excel bar chart

  1. #1
    Registered User
    Join Date
    12-22-2012
    Location
    UK
    MS-Off Ver
    Excel 2016
    Posts
    13

    Plotting outlier in Excel bar chart

    I have a data set that I want to turn into an Excel bar chart. My challenge is that one of the values is approximately 25,000 units whereas all the other are in the range of zero to 3,000, so when I create the chart it's going to be impossible for people to compare most of the values (it's going into a PPT presentation). What I want to do is create a chart similar to the one below, where as you can see the largest value has been compressed. Does anybody know if this can be done in Excel 2013?

    Thanks

    untitled.gif

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Plotting outlier in Excel bar chart

    Hopefully something like this will help. https://alesandrab.wordpress.com/201...nd-bar-charts/
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

  3. #3
    Registered User
    Join Date
    12-22-2012
    Location
    UK
    MS-Off Ver
    Excel 2016
    Posts
    13

    Re: Plotting outlier in Excel bar chart

    Thanks, just what I was looking for and very helpful

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Plotting two sets of data with different dates on same line chart (Excel 2010)
    By archedjumpshot in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 01-29-2015, 01:05 PM
  2. [SOLVED] Ignoring Null Values when Plotting an Excel 2003 Bar Chart
    By molson1973 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 02-18-2014, 06:11 AM
  3. Excel chart plotting, depending on weightage
    By learning in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-27-2010, 05:35 AM
  4. [SOLVED] Excel 2003 xy chart - problem plotting more than 330 points
    By ehmcneill in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-16-2005, 08:25 PM
  5. How do I test outlier in Excel?
    By Koos jubileert in forum Excel General
    Replies: 1
    Last Post: 08-30-2005, 10:05 AM

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