scale

  1. M

    Chart - call to MinimumScale function makes the plot disappear

    Hello everyone, I am curently trying to create a chart with VBA and I am facing some dificulties trying to figure out how to adjust my X-axis. I use dates on this axis and if I do'nt set its the min and max dates programatically, the plot just goes from 01/01/1900 to 19/02/1900. The thing is...
  2. V

    VBA: Adjust y-axis scale based on 1 data series

    Hi. I am making a chart with multiple data series. One of them is a fake series that I use to shade so the values are way higher than the normal series I use and excel accounts for that when auto scaling. Is there anyway in VBA where I can specify which data series to base the auto scale? Thanks.
  3. A

    Nested IF(AND Statement - Index Match or Array?

    Hi, I am trying to work out who in my data is eligible for a pay increment. I have a 2 column lookup table $A$2:$B$28 that shows Grade in Column A and Scale Point Ceiling in Column B e.g. Column A GRADE Column B SCALE POINT CEILING Administrator...
  4. T

    Function or VBA for bonus scale

    Hi there, I need to calculate the bonus to be received by an employee who has generated total sales of for example $180.000. After all the calculations he must take $6.800. The bonus scale is 8% for amounts between 120001-130000, plus 10% for amounts between 130001-140000 plus 11% for...
  5. P

    Place a symbol in a cell based on value in adjacent cell that correspond to a scale in top row?

    I have a lot of rows with cognitive data, range 20-80 (standardized T-scores) in column B that I want to represent visually in column C with a symbol (square or small circle) that correspont to the T-score scale in the first row (20-80). In addition, I need vertical lines that represent the...
  6. T

    Chart Macro Question

    I have created a simple macro to scrape/download share prices from yahoo. I have created a bog standard candlestick chart and I would like the ability to automatically adjust the y axis scale (price scale) via a macro so that as I download a different stock price the chart automatically adjusts...
  7. D

    Likert Scale to Percentages of Particpants

    I was given a data set with a Likert scale (rating 1-5). The data set has around 270 participants, and 8 questions (all with the rating of 1-5). The data has been coded (so it looks like it was taken straight out of Access- including the auto number feature on the far left). However, I need...
  8. E

    Format Comment using VBA

    I currently am able to use vba to comment a picture I have rooted in a specific cell, but am having trouble sizing it properly. My current code is below: Sub Comment() Set rng = ActiveSheet.Cells(9, 1) rng.AddComment rng.Comment.Text Text:="" rng.Comment.Shape.Fill.UserPicture...
  9. C

    Awarding Points on a Scale

    Hi Excel newbie here and would appreciate any help someone could give. I am trying to take points away (max 100) for exceeding a target value Lets take the example a service loading The team have a target of 350 (milliseconds) anything under that time gets you 100 points automatically...
  10. S

    Taking performance goals, converting to scale 0 - 10

    So i have had several Microsoft Techs try to solve this and while we seem to get close, something is missing. I have a spreadsheet that takes employee standards and attempts to score the standards on a scale from 0 - 10. For example...
  11. R

    VBA editor or IF function? -

    I'm not sure this is possible. Maybe VBA? Ex 1: I want to select A3 (Turn Down Ratio), B3 (Number of sets), and C3 (Full Scale). Then in column E it will divide the Full Scale into 5 sets by the Turn Down Ratio in A3. Then shown in Ex 2, if I change the Value in A3 and B3, it will then...
  12. K

    Conditionally Formatting (Highlighting) Top 5 / Bottom 5 when there are two scales in same column?

    I have a column of topic scores. Around 50 cells. I am trying to highlight the bottom 5 and top 5. There are about 10 of these topics that are on a reverse scale meaning a lower score would actually be better and could put them in the top and a higher score would be worse and could put them in...
  13. S

    Plot Area Tile Picture Scale Offset Issues

    Hi All, I have the below code which sets the plotarea fill as a high res map of the world Jpg . My plan was to scale and offset to particular parts of the world to then add points over them. Sub add_image_background() Dim Cht As Chart: Set Cht = ActiveChart 'Image...
  14. B

    Set Excel Chart so maximum scale of y-axis is at least 100%

    Greetings, I have a bar graph with the y-axes expressed in percent. The minimum percent value is always 0%. However, the maximum percent value can exceed 100%. Sometimes, depending on the data, if I set the y-axes maximum scale for Auto, the chart may have a scale that is less than 100%. I...
  15. J

    Waterfall scale query

    Hi guys, I hope someone could help me on changing the scale of my waterfall as the movement is relative small comparing to the budget and actual. So I have budget number of £10K and the middle movements are in between £100K and £11K, if I want to show the movement in a bigger scale, how to...
  16. I

    Two Way lookup with exact and approximate match

    Hello, I am trying to figure out a two lookup that will lookup two columns of data, one with an exact match and the other with an approximate match. i.e. My issue, is that when i deal with thousands of Materials, with different scale sets, I pickup the wrong scales with Scale lookup 1. SO My...
  17. J

    Help With Macros

    Hey guys I have this excel file I want to change one thing on and I cant figure it out. On the sheet called "Input" I want to be able to select a scale number in the upper right hand corner and have it copy over all of the information from the sheet called "Database." Right now when I select the...
  18. B

    color scale conditional format

    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?
  19. N

    Colour scale conditional format does not refresh....

    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...
  20. K

    double logarithmic scale

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top