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.
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 * below to say thanks.
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
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
One test is worth a thousand opinions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks