I want to make a line chart that plots a variable over time (say, monthly) and that shows upper and lower limits as the 2nd and 3rd plot. My table layout, boiled down to the bare essentials:
Col 1 = Measurement date
Col 2 = Measurement (pressure, for example)
Col 3 = High limit (never varies)
Col 4 = Low limit (never varies)
The chart/graph in this case would show at a glance how water pressure varies over time and when it goes over (under) a limit. The table has about 50 variables.
I am using the Find fuction to look for values in cells that contain text in both lower and upper case. I am comparing the values that I have stored in a lookup table. I am running into trouble when the lookup table doesn't match the text cells....
For Each cel In Range("E6:AI15").Cells If IsError(cel.Value) Then Else Select Case UCase(cel.Value) Case "H" cel.Font.ColorIndex = 0 cel.Interior.ColorIndex = 3 Case "S" cel.Font.ColorIndex = 0 cel.Interior.ColorIndex = 10
but I want the cells to accept both upper and lower case values and format the cells accordingly ie. H or h, S or s
The values in F4:F14 are changed depending on the value in F2. The rows in green have a fixed value. The row in yellow has a lower limit (170)and upper limit (195). I cannot get a formula in F14 to perform this function.
I need to change the all Upper Case character to Lower case character for all cells. See below my code, i am getting error message, Tye Mismatch. "cell.Value = LCase(cell.Value)"
=upper("venkat") returns VENKAT =upper(a1) returns the text in A1 in upper case
similary lower proper will turn the first letter into uppercase
is this what you want;.
Terry <terrybetts11138@hotmail.com> wrote in message news:dbl0dk$poa$1@nwrdmz02.dmz.ncs.ea.ibs-infra.bt.com... > Win XP Pro > Office 2003 > > Using "Excel" and wish to select any text in a worksheet to ALTER the case > to either upper or lower. > When using "Word" it is easy via the menu. > Is there a menu driven option in Excel of using a function for this purpose.
find the "add in" that converts the case text from lower to upper in excel. i've already downloaded this before but can't remember where from and it is much easier than creating a formula or a macro
I've got a column of data that I need to split into further columns, the only way of identifying the split from the data is if a lower case character appears next to an upper case character.
For example, a cell in column A could look like;
Computer ProductsDrivesDVDExternal And I'd need to split that out to cover columns A B and C with
Computer Products / Drives / DVDExternal I'd need to do that for all the cells in column A.
Im looking to use vba to determin upper and lower quartiles, i know how to do this through excel "QUARTILE(B9:B59990,1)", but was wondering if anyone would of any code to do this in visual basic?
I want to generate random times in excel between upper and lower limits , which i can do , but i also want dates in same cells with out randomization , means dates should act independently and time should randomize
it should be something like that
8/1/2013 05:55 AM 8/2/2013 07:55 AM 8/3/2013 04:44 AM
I have a table that I use to generate about 20 graphs. The lower and upper limits can be manually altered in the table. If the user leave those 2 cells empty, I want the upper and lower limits be determined by default by Excel. So that the limits don't have to be entered for every graph in order for the graphs to be generated without any debugging error.
I would like to format a row of cells so that when a word is entered into the cell it automatically becomes a capital.
I need the word to be capitalized so that I can use it in a custom function. The function uses the word from this cell and goes through a bunch of cases in determing how to classify the string.
I think more than one solution is possible and I would greatly appreciate some feed back, I've tried looking into turning all the letters of a string in my VBA code to capitals, or a way to format the cells, so that the string is already capitalized when entered into the VBA code, but I'm still a novice at VBA and unsure on how certain commands work.
here is a sample of my vba code.
Function WeightI(Shape As String, sDim As String, dLenFt As Double) As Double Const pi As Double = 3.14159265358979 Const Ft2In As Double = 12 Const dDen As Double = 0.2835 ' density of steel, pounds per cubic inch
I am trying to detete rows that have several specific values, upper and lower case, (A-H) in any of several columns (B through H). I can delete upper and lower case "D"s in column B, but I'm having difficulty stringing together several variations and getting at the "D"s that are midstream (such as: ADeC), I tried ("*D*") to no avail.
With . Cells(Lrow, "B") If Not IsError(.Value) Then '**** If LCase(.Value) = LCase("D") Then .EntireRow.Delete
How can I add missing values to the axis in a pivot chart line chart? I have a numerical X-axis with values such as 0,1,5,8,14, etc. I have another set of Y values that correspond to the X values. If this was an XY-scatter plot I'd be able to plot X vs. Y and connect the dots for "gaps" in the X values. Since it's a pivot chart I cannot use an XY-scatter plot, I can only use a line chart. The line chart doesn't give me the ability to add the "missing" values, so it gives the impression that my data is more closely packed than it is. The data source is external to my spreadsheet, so I cannot add the values before creating the pivot table/chart.
First one asks the user what month their querry starts in - ie january 2011
The second one asks the user how many months their querry is for - ie 12
I would like to know how to use the second input box to set the limit of data for the first box
The first box puts a date in "L2" - ie L2 = January-2011
I would like for the second input box to autofill the dates down col L based on the number selected in the second inputbox. i.e. january-2011, February-2011 and so on.
I M trying to get the lower values between to cells and have the lower valued cell highlighted,,,i have over 43 thousand lines of data to go throughand i was wondering if there was a quicker way to do this,,,for example cellA1 is $4.25 and cellA2 is $5.25 i want cell A1 to be highlighted,,is there a way?
if there's any way for vba to detect if each individual character in a string is in caps, and if so, convert to lower case, and if it's in lower case, convert to capitalized
The text will vary in length and content... so he wants to see how we can change: "This Is Strange" to "tHIS iS sTRANGE" "THIS IS STRANGE" to "this is strange" "this is strange" to "THIS IS STRANGE"
I have a column of data that I'd like to visualize in a line chart. The cells in the column contain formulas that calculate numbers added to other sheets every month. The adjacent column has the names of each month. New data appears when the data for the month is added.
I'd like to ask the chart to not display the values that are currently zero, because we haven't arrived at that month yet. So, for instance, the cell in the column for November 2011 has a zero, because the range it sums has no data in it yet.
Is there a way to do this without having to go back to each chart every month and change the range to add-in the new data?
I have a spreadsheet where I track income (positive) and expense (negative) items and compare budget to actual amounts. I want to create a simple bar graph comparing budgeted amounts to actual amounts for each item.
However, when I do this, I see all of my income items above the line (pointing up) and all of the expense items below the line (pointing downward).
Is there an option I can select to just use absolute values for the items so they all appear above the line?