scale

I want to 3-color scale conditional format with cells that contain formulas (Left & Vlookup) this formula brings back a number between 1 and 5 - the cell format is also in number. It does not work, the cell's stay blank instead of colored as should be depending on the values?

Hi, I have a colour scale conditional format setup to show green at 100% and red at 0%. This works perfectly, however, when using filters or slicers, the colours vanish, for them to return i need to scroll down and back up through the page, the colours seem to then refresh? Hopefully this is a...

Hi Would anyone solve my problem? I would like to create in excel a graph for which the y-axis is on a double logarithmic scale, while the x-axis is one-time logarithmated. Below is an example of a chart that I would like to write in excel...

First of all let me state that my coding ability is very limited. I have a pallet scale display hooked to Excel via serial port. I currently have the excel doc set to display the scale value to Sheet1, C1. What I want to due is create a macro to calculate the mass rate of change (i.e. pounds...

Good Afternoon, Normally I partake in the MS Access section of this board, however I have a quandary in Excel. I would like to have the Max value used for determining the cell's highlight when using the "Graded Color Scale" to be based on the value of Column F for each row. How can i do this?

Hi Everyone, I wascurious if there is a way to have VBA scale a logarithmic scale to the next base10. For example, I have written a series of code that generates numerous plots, each with varyingmaximum y values based on data within a column range. Iwould like to find a way for the code...

Line of best fit that isn’t. Have a look at this graph. It shows the latitude and longitude of a paraglider circling whilst drifting over the ground…. (if I’ve clicked the correct buttons, a good quality image of the graph called ‘LineOfworstFit.png’ should be here http://ge.tt/1cadawo2 )...

Hi All, I kindly ask you to help me out on what I'd like to reach. I have a list of numbers (around 100) and I'd like to get all the potential combinations of sums in pairs. To simplify: If I have these three numbers: 1 - 2 - 3, I would like to get the follwing result. 1+1= 2 2+2= 4 3+3= 6...

Hello, I could use some help with a sliding scale formula. I need a formula that does the following: if a sales rep achieves 85% of sales, they will achieve 50% of their bonus. If a sales rep achieves 100% of sales, they achieve 100% of their bonus. If they achieve 115% of sales, they’ll get...

I have a sheet with two different "tables" (not formatted as tables) and I need to print them each on separate pages, one page each. The bottom "table" is just fine to be printed on its own page, however, the top table is too tall and therefore needs to be scaled to fit on one page. When I scale...

Hello! I have a diagramm in which the x-axis gets its scale from another sheet (=sheet3!$A$3:$A$74). In the diagramm that shows like weeknumber (18 19 20 and so on). Now I need to put in 6 more weeks and changed to =sheet3!$A$3:$A$80, but the diagramm will not extend the weeknumbers. I am not...

I am trying to link several workbooks together so that I may provide my work with an easy way to calibrate tools. I have the main interface excel workbook which takes user entry and I want it to populate data based on different dropdown selections and I them want to save data to different files...

I am trying to paste special and manually format the object to a certain scale. However, the scale size always changes. Here is my code: With Selection.Tables(1).Range.Cells(2).Range .PasteSpecial Link:=True, DataType:=wdPasteOLEObject, _ Placement:=wdFloatOverText, DisplayAsIcon:=False...

Excel 2011 32 bitBCDEFGHIJ2User InputAutomatic3NameMonthProgramStarting LessonLast Lesson CompletedNumber of LessonsSectionPacing4John SmithSeptemberRMK2141C212Below5Bob JonesOctoberCRA116C16On TargetExcel Scale I am interested in setting up a formula that will automatically display a colored...

<tbody> So I Have 3 sheets "Scale", "Incentive Calcs", and "Data" What I am trying to do here is to get a $/Direct value from Column R in sheet "Scale" into the sheet "Incentive Calcs", Column I based on each row's values from Columns G and H. Example formula from Cell I2 is this...

I have a sheet where I inserted a map as a background image. I put information in various cells based on their proximity to the map. Works great - on my machine. A coworker opened the same file on his machine and the background image scale was different in relation to his cells (I'm guessing...

0 down vote favorite I have connected a weighing scale to my PC via an RS-232 to USB converter cable. My goal was to create a command button in excel 2007 that would place the weight from the scale into the selected cell. I got it to work using the following code in a userform. Private Sub...

Hi, I have a dashboard I have compiled which uses a table output from PowerQuery. There's a VBA script doing a few formatting things too. I would like the chart series to scale to reflect size of table returned. I'm a bit confused because this seems to work for a while and then the range...

I have a form that when it's viewed on smaller monitors/resolutions, part of the form is cut off. Does anyone if there is a way so when the form size exceeds the monitor/resolution size that it scales down the full form to near maximum size and adds the scroll bars? I don't want to change the...

So I am in a predicament. We have orders that range from $500 to over $500,000 and we charge a certain amount for an extra condition and we want to base that cost off a percentage of the order. The smaller orders we charge 2% and the max we will charge will be 0.5% at $500,000. Anything in...