+ Reply to Thread
Results 1 to 4 of 4

Horizontal axis limiting formula in xy scatter plot

  1. #1
    Registered User
    Join Date
    11-02-2011
    Location
    Delhi
    MS-Off Ver
    Excel 2010
    Posts
    43

    Horizontal axis limiting formula in xy scatter plot

    Dear all
    I have prepared a xy platter plot. I want to limit minimum and maximum values of x without changing the horizontal axis range or changing the values in the series. If certain value is less or more than those limiting values it will not consider those values while plotting. I have attached the file. Intended chart is in sheet 1. Need guidance. Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,543

    Re: Horizontal axis limiting formula in xy scatter plot

    Hi S K Roy,

    Have you found the Format Axis Dialog yet?
    http://www.homeandlearn.co.uk/excel2...2007s3p12.html
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    11-02-2011
    Location
    Delhi
    MS-Off Ver
    Excel 2010
    Posts
    43

    Re: Horizontal axis limiting formula in xy scatter plot

    Hi Marvin
    In format axis we can limit the minimum-maximum value of the axis, right. But I do not want to change the axis value as such because I have to plot other curves with different limiting ranges. Instead I want to limit the datapoint value of individual curves. So that I come to know where it is hitting the maximum or minimum. Hope you understood my intention. Thanks.
    S K ROY

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,543

    Re: Horizontal axis limiting formula in xy scatter plot

    Hi,

    If you did an Advanced Filter of your data to another place on the sheet and then graphed the filtered data, would that work?
    http://www.excelfunctions.net/ExcelAdvancedFilter.html or
    http://www.contextures.com/xladvfilter01.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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