Results 1 to 8 of 8

How to eliminate outliers in graph

Threaded View

  1. 08-13-2013, 08:31 AM #1
    plumberef
    plumberef is offline
    Forum Contributor
    Join Date
    10-24-2012
    Location
    malaysia
    MS-Off Ver
    Excel 2021
    Posts
    114

    How to eliminate outliers in graph

    When viewing some graphs, sometimes I need to ignore some outliers. See attachment.

    Like to know whether it is possible to click on the outlier data or the corresponding x on the x axis and the graph will be updated without this outlier data.

    I know I can go to the data set and remove the outliers but want to simplify by doing it on the graph.

    Many thanks.
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. sum and stdev outliers
    By gergleb in forum Excel General
    Replies: 0
    Last Post: 12-01-2011, 12:46 PM
  2. scroll graph ...how to eliminate #REF
    By jw01 in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 04-21-2011, 02:18 PM
  3. Outliers In Graphs
    By Mordred in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 01-02-2011, 08:50 AM
  4. Excel 2007 : best fit line without outliers
    By bored in forum Excel General
    Replies: 3
    Last Post: 11-23-2010, 05:39 AM
  5. Boxplots with outliers
    By Confuzzled. in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-17-2006, 03:40 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1