Set Chart/Graph Minimum/Maximum Scale To Nth Smallest & Largest Value

May 15, 2008

I am trying to manually format a few graphs in my sheet. I, however, leave the major units of the axes to be automatically calculated. The code that I use is given below:

ActiveChart.Axes(xlValue).Select
With ActiveChart.Axes(xlValue)
.MinimumScale = Range("Min").Value
.MaximumScale = Range("Max").Value
End With

Now what this does is that it sets the maximum of the scale exactly equal to maximum of the range being plotted and hence a few parts of my graph overlap with the border of the plot area. Is there any way in which I can round the max and min scale of y-axis to the next highest and lowest major unit respectively or may be add and subtract a value proportional to the major unit of the y-axis. I cannot add a constant in the code given above since I that does not suite my requirements.

View 2 Replies


ADVERTISEMENT

Determine Minimum Scale Value Of Chart Axis

Dec 14, 2007

how to get the min value scale value off a graph when .MinimumScaleIsAuto = True?
The reason I ask is that I want to make my baseline for the graph that min number so that names from the x axis are not sitting in the middle of the graph. Incognito Auto Merged Post;I feel real bright...just playing around I found my answer...

With .Axes(xlValue)
.MinimumScaleIsAuto = True
.MaximumScaleIsAuto = True
.MinorUnitIsAuto = True
.MajorUnitIsAuto = True
.Crosses = xlCustom
.CrossesAt = .MinimumScale
.ReversePlotOrder = False
.ScaleType = xlLinear
.DisplayUnit = xlNone
End With

View 2 Replies View Related

Maximum & Minimum Axis Values From Chart

Nov 20, 2009

how I get the maximum and minimum values of the axis from and excel chart? What I mean is I want to specify a chart, and output in the same excel worksheet the values for the maximum and minimum of the two axis.

I have tried various searches, but cannot come up with the answer, although I have a sneaky suspicion it in here somewhere.

View 9 Replies View Related

Using Scroll Bar To Modify Axis Of Chart - Maximum And Minimum Values By Default?

Sep 22, 2013

how to link axis properties with a scroll bar (two scroll bars).

The idea is to be able to modify the maximum and minimum values for the axis in case there are outliers which might cause problems by analyzing the chart.

The Guideline in the scroll bar should be set to its maximum (all the way up) by Default, meaning that if there chart behaves itself well there is no need to change its axis values.

The same applies for the minimum guideline of the scrollbar but it should be sent all the way down by Default.

View 1 Replies View Related

Largest And Smallest Sequences

Jan 12, 2009

I am using excel 2007 and I need help with the following if anyone would be kind enough. I have a dynamic array that consists of stream of 1's and 0's. I want to be able to find the largest sequence of 1's and the smallest sequence of 1's. So at a point in time the array mite be 111110001101111000 and I want to be able to dertermine the longest contiguous sequence of 1's. But as I say the array is dynamic and so I need to do that after each input.

View 8 Replies View Related

Lookup Nth Largest/Smallest Value

Aug 17, 2007

Is there a way to reverse a lookup function?

I have a s/s attached, basically B is like an output of figures after some calculations. And I am trying to find from largest to smallest values and then having column E reflect the Letter beside that number...

tried using match but messed up.

View 3 Replies View Related

Find Largest And Smallest Value For A Number

Jan 25, 2014

I want to find the largest and smallest value for a number... E.g.

68734 the largest value is 87643 and the smallest value is 34678

39823 the largest value is 98332 and the smallest value is 23389

43089 the largest value is 98430 and the smallest value is 3489

View 4 Replies View Related

Sorting Numbers From Smallest To Largest?

May 10, 2013

There must be something I'm doing wrong, because I have a list of numbers and when I select Data --> Sort --> Column G, I am not given the option of sorting "From smallest to largest". Only from "A to Z" or viceversa.

View 3 Replies View Related

How To Filter Dates From Largest To Smallest

Feb 20, 2014

I'm trying to create a formula that will allow me to filter the dates from largest to smallest while having a text in the formula. Right now I'm using:

=K2-M2&" Days"

But the dates are all over the place,

View 3 Replies View Related

Highlight Smallest & Largest Values

Jul 1, 2008

I have a work document with multiple rows of information. In each row I need to locate the maximum and minimum values. (The rows aren't long - there are about 10 values in each). I then would like to turn the font of the lowest value in each row red - and the font of the highest value in each row blue. I would also like to be able to skip blank or unimportant rows.

View 2 Replies View Related

Output One Instance Of Smallest AND Largest Value In A Range

Dec 5, 2013

I am looking for a formula that will output the highest and lowest value in a range. Column A contains a range of numbers, some of which repeat and in column B i'd like to extract ONE instance of the highest and lowest value in Column A, preferable the last instance.

See example below and in column B the desired output.

Column A
160
90
120
90
120
160

Column B
blank
blank
blank
90
blank
160

View 5 Replies View Related

Sorting Table According To The Field From Largest To Smallest

Jun 21, 2013

I am doing a macro that will access a specific sheet of my workbook, a specific table, and will sort the table according to the field "Nominal", from largest to smallest. I have tried with this but it doesn't work:

Sheets("F.C.SSA-View 2").Select
Application.CutCopyMode = False
ActiveWorkbook.Worksheets("F.C.SSA-View 2").ListObjects("F.C.SSA_View_2").Sort.
SortFields.Clear
ActiveWorkbook.Worksheets("F.C.SSA-View 2").ListObjects("F.C.SSA_View_2").Sort. _

[Code] ....

View 1 Replies View Related

Find Smallest And Largest Non Zero Date In A Range

Aug 13, 2008

I am having some data running into 60 (C:BJ) columns and 200 rows. It is the record of dates query raised and answered with refernce to query number in the A coulmn. I have zero value as entry for the unused cells in this range due to some constraints. I need to find the smallest and the largest non-zero date in this range for analysis purpose. I plan to use the difference between these 2 dates to calculate turn around time for a query.

Problem is to find the smallest and the largest non zero date within range C6:BJ6 which would be used as input in the Networkdays formula.

View 9 Replies View Related

Excel 2010 :: How To Auto Sort - Largest To Smallest Value

Nov 4, 2013

See post below. I want to have the column listed as per to auto sort to the largest to smallest value. This value will change throughout time.

I have data in columns a-n and rows 3-14. I want column "l" or the 12th column to auto sort from largest to smallest value.

View 1 Replies View Related

Return Cell Address Of Largest & Smallest Value In Column

Jun 2, 2009

How would I return a cell reference (address) to a cell that contains the largest number in a list?

I tried using "Address(large....) where I get the correct column, but the returned row # is the actual value in the cell (the highest # in the list).

I eventually will want to delete the highest number to leave the cell blank.

View 3 Replies View Related

Scroll Scale Of Graph

Dec 7, 2006

I have a big set of data, where I requires to zoom in to view the details of the graph (by scaling the X and Y axis). I am thinking of a graph that can use 4 scroll bar to control the zooming. 2 for each axis, where one control the difference between the maximum and minmum value (Zooming effect, minimum value always the same), and one to scroll the range of the data without zooming, (maximum - minimum) always the same.

View 5 Replies View Related

Counting Number Of Days Over A Time Scale - Graph

Oct 6, 2012

I have got a project that has several hundred starts and finishes. I want to count them over time to use as an indication of progress. ( I want to show this graphically)

I have got the graph working but it is pretty long handed.

I have tried using a pviot table and picvot graph which almost does it but has a few problems (if there is no data in a month then it wont create an entry for the month, and the cumulative over time is not quite working).

Both examples are in the attached file : Progress Curve ozgrid1.xlsx

View 6 Replies View Related

Sum Minimum & Maximum From Each Row

Jun 13, 2007

data in 3 colums (A2:c100)

Would like to sum the maximun values in each row together.

is Max(A2:C2) + Max(A3:C3) + Max(A4:C4) ........

I assume whatever works with max I can change to min.

View 9 Replies View Related

IF Using A Minimum And Maximum Function?

Aug 5, 2014

I have 3 columns 1st one has numbers that reference a wellbore.

2nd have a depth

3rd has a number value (a mud weight) volume

Well API example Depth Weight
42050102600000 10000 10.2
42050102600000 9500 9.2
42050102600000 6500 8.5
42050105000000 12000 11.0
42050105000000 7500 6.0
42050105000000 10200 9.5
42050110100000 8000 8.0
42050110100000 9500 9.2

I want the formula to give me based on the well API number the max depth and the weight associated to that max depth. And the minimum depth and the weight associated to that minimum depth. I'm not sure how to say it in a formula. I don't want to use VBA.

View 8 Replies View Related

Find Minimum Value Corresponding To Maximum Value

Jan 16, 2010

I am having trouble with large data sets of rents by market: trying to find the peak rent in a time-series, and then look for the next trough rent in time. I tried using the Newsletter 3 techniques which feels like the right direction, but I am not getting the nesting right or some of the parameters in the functions.

So, within each time-series I need to find the MAX value (peak rent), wherever that is in the array. Then I need to look to the right of that exact MAX value and find the exact MIN value (trough rent), whereever that is in the array (again, to the right of the MAX value).

A small sample of what the data set looks like:

2008 Q22008 Q32008 Q42009 Q12009 Q22009 Q3
Atlanta771773768761749756
Austin770786784779776776
Baltimore947948949950950953
Boston1,6471,6601,6541,6481,6301,613
Chicago998998996985984986

View 4 Replies View Related

Maximum And Minimum Time Value In A Range

May 17, 2014

I have used max and min function to display minimum and maximum time value; however, it is not displaying the correct time value from the list. I think there is a better formula to achieve this. From the sample data displayed below, minimum time value should be 11:30PM and maximum time value should be 6:30AM

See sample data below:

4/1/2013 11:45 PM
4/1/2013 11:30 PM
4/2/2013 6:30 AM
4/2/2013 6:15 AM
4/2/2013 6:00 AM
4/2/2013 5:45 AM

[Code]....

View 8 Replies View Related

Minimum And Maximum Value In Sumproduct Formula

Dec 1, 2008

Is there a simple way to find the min and max value for my formula below

HTML =SUMPRODUCT((Data!$J$2:$J$10000="E700")*(Data!$M$2:$M$10000>'Rental Rates'!$A3)*(Data!$M$2:$M$10000<'Rental Rates'!$B3)*(Data!$M$2:$M$10000))

View 2 Replies View Related

Match Criteria According To MINIMUM And MAXIMUM

Nov 27, 2008

I need a macro that will search MIN and MAX columns and identify which horse has the maximum number in both the MIN and MAX columns an example is highlighted yellow in the attached spreadsheet. If there is a selection i want the macro to keep the horse that matches the criteria along with the race date and time e.t.c (header) but delete all other horses in that race. If there are no selections that meet the criteria in a race i want it to delete all details for that race including headers and go to the next race.

View 2 Replies View Related

Listbox Minimum & Maximum Range

Jun 10, 2009

I have the two buttons on userform "viewer" that try to push the listbox past it min and max range. resulting in a error. Could it be that if listbox is at min it set the button to hidden.

View 4 Replies View Related

Finding The Minimum Value In A Column That Comes After The Maximum Value

Dec 11, 2008

Say I have 2 columns that in basic form look like this:

Column A Column B
Jan 1
Feb 0
Mar 7
Apr 4
May 15
Jun 2
Jul 5
Aug 4

First I want to look up the max value in this column. This is easy =max(b1:b8)
Then I want to know the minimum value that occurs after the maximum value. Thus the answer would be 2.

View 3 Replies View Related

Count No Of Maximum / Minimum / Median

Apr 22, 2009

here is an attachment... i have found array fromulas for finding Maximum, Minimum & Median. Now i need to find the no of Maximum, Minimum & Median.

View 2 Replies View Related

MAXIMUM/MINIMUM Formula With Time

Jul 13, 2009

I have the following formula C= day in DD/MM/YYYY and D = Time in HH:MM format and BJ5 is the date

View 3 Replies View Related

Return Data Corresponding To Minimum & Maximum

Nov 26, 2008

Please see attached file which is data for horse races (this is a small example of the data i will be working with). I need to find the largest values from the MIN and MAX column (shaded Grey) range for each race. I want to be able to add a function that will allow me to quickly identify which horse has the largest number in both the MIN & MAX columns example on spreadsheet is highlighted RED. It would be handy if it would inform me if the criteria has been met by highlighting it or by placing some text value in an adjacent cell on my spreadsheet i have used the example "Y".

It would also be beneficial if that race be deleted in its entirity if there are no horses which meet the criteria above or similary if all other selections within that race be deleted if ther is a horse which meets the criteria. If there is a selection within that race i will need to keep the row that includes the heading which is coloured blue on the attachment.

I will be working with 20,000 or more selections at a time so it is important that they can be identified quickly for ease of use.

I have tried the functions i know such as MAX and LARGE but this requires me to do alot of work when you consider the ammount of data i'm required to work with.

View 9 Replies View Related

Calculate Minimum & Maximum Of Range

Apr 23, 2009

Is there a easy way to calculate the MAX or MIN of column B dates to column A items that have say many different dates in column B? see attached excel file to show what I am looking for. How to calculate the MIN value in column "B" of the items in column "A" with formula in column "C"...

View 2 Replies View Related

Lookup Maximum & Minimum. Return Corresponding Row

Nov 2, 2006

I have searched your forums and thought I had found a sufficient answer but could not get the vba to work. So any help is greatly appreciated. I am trying to determine a max value from a list then put that value in a cell. Next I want to determine how many times and on what day that max value occured. From there take the value and concatenate them adding a "," between them I have attached an example. I would like the values placed in cells F1 and H1 (the other is a min value and when it occurred)

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved