scale

Hi all, My organisation currently use a 1-4 scale to score our grounds maintenance contractor's workmanship. However, our contractor use 1-7. I need a formula that will convert one to another with 1=1 and 4=7. I need the results to show down to 2 decimals i.e.: 1.00 = 1.00 1.50 = 2.00 2.00...

I'd like to create my own max and min for an excel chart axis scale for both my primary and secondary axes. I know this needs to be done via VBA but I don't know where to begin. Any tips?

Hi guys, I posted asking for help for a stamp duty calculator recently and received some awesome solutions from the users on here. I tried tweaking the formula for this exercise but couldn't get my head around it. This time I'm trying to calculate land tax due for properties in Tasmania using...

Hi guys, I have got a properly working code that automatically updates the axis labels. However, this macro updates all axis' for all charts in the active sheet. I was thinking of creating a set of name managers (2 for each graph) and let the macro refer to those name managers. I am not sure...

Howdy, I have a chart where the values on the x axis range from -6m to +280m. I would like the major units to be $50m starting from 0. I would also like a minimum value of -10m and a maximum value of +300m. Given that i've fixed the min and max values, How can I get the axis major unit...

Hello, Looking for some help in completing a Macro I have been writing. I have a rather lengthy Macro that inserts images from a hard drive into merged ranges (e.g. D7:D23, D33:D49, D59:75 etc) What I'm looking to add is VBA language that says: -If the Picture Width > Column D Width, Scale the...

I'm curious if there are any modern solutions related to creating a probability scale in Excel? Peltier provides a solution that has been around for quite some time (Simulated Probability Chart Example). With the changes in Excel that have been made, are there any other solutions out there that...

Hi, I have a dataset which is widely distributed. A log chart can display the pos values fine, but I need the same treatment for neg values also which obviously rules out log. My values for example range from -5 to +5 for both axes. There are a lot of data points in the 0 to .03 range and -.03...

I'm curious if anyone has experimented with this before? I'd like to print a chart, and force it to scale to match the printer page size for printing purposes only (not modify the chart as it appears in the sheet). Rationale - The chart fits a design "as-is" in the workbook. But the chart...

Hi Everybody, After two hours trying to find this over internet, I finally gave up and I'd like to asf for your help! Say that in one sheet I've a table with say 500 columns and 6000+ lines. In other two sheets of the same workbook, I've made 50+ charts to get the information I want from the...

Hello everyone I am making an excel grafh with two x-axis. Making these two axis is no problem, however, the 2nde x-axis is a binomial transformation of the first x-axis. Therefore, the scale is different. Is there an elegant solution to make the values of my second x-axis correspond to my...

I'm developing an application on a Macbook air that will run mostly on PCs. I have two questions: 1. I need to write a routine which scales the UserForm for screen resolution, as most of the PC users I work with use a lower screen resolution than what I use on my Mac. I've seen sample code...

Hi Guys I was wondering if any of you experts could tell me how to create a slider scale type bar chart if at all possible. I'm due to produce my monthly energy reports at work and want to make them look a little swankier by updating and refreshing the overall format a little. A portion of my...

Hi, this should be really easy but im stumped. A1 needs to show "0.95%", or "0.8%", and so on, based on a figure entered into A2. Doesnt need to calculate the percentage out or anything, just return a figure based on A2 being within a certain range. Im confused by IF and AND and cant get that...

Hi all, I've been doing tons of searching and haven't found any answers to this question.:banghead: I'm looking for code to edit the tiling options for the fill picture of a shape. I have been able to add the image to the shape using the following code: Sub AddImage() MyPic =...

I have a need to present 2 sets of values on the Y ( vertical ) axis but the Scales differ appreciably. I 'd like to know how can I present these so that I can appreciate the changes in both these values. e.g. X fn of A B ( Y axis ) When I plot X against A & B because B has a HUGE range ...

I have been stumped with this, mainly because of the slightly annoyingly tight requirements :s Essentially what I'm trying to do is combine PrintTitleRows, PrintTitleColumns, Custom Print areas, and Scale to fit page. PrintTitleRows needs to stay at 86:91 PrintTitleColumns needs to stay as A:A...

I'm comparing Excel 2003 to Excel 2007. In 2007, you can insert a background and make it fit the page to print by using a header. In 2003, you can insert a background also using a header, but how do I make it such that the picture fits the page in 2003? Thanks

I am using a rotated bar chart to show the following data: Excel WorkbookABCDE1*POORFAIRGOODEXCELLENT2Preserving open space land**2*3Providing opportunites for recreation**2*4Overall quality of preserves**2*5Managing natural resources*1.9**6Overall job*1.9**Performance Rating I would like to...

I have a worksheet that includes user input regarding the number of months required for the cash flow. I want the cash flow spreadsheet to automatically adjust the number of columns pertaining to each month in the cash flow (the months are listed on the top of the speadsheet). I cannot find out...