scaling

I need some help having a macro or something that can take a data set (45 check points = X and % stock used = Y) and it’s bell curve, compress it to fit a smaller scale such as 1-15 checkpoints and maintain the bell curve shape. I want to type in a stock amount and weeks and it spits out a new...

Hello. I am having trouble figuring out the relationship between page scaling and the inclusion of print titles. Please see the attached image for reference. Thank you in advance for your help. Basic Question: If I have a sheet scaled to fit on one page and no print titles are included it...

Hi, I have multiple workbooks and would like to check that what the scaling is on each of the tabs before I print it out. Maybe some script that gives me a report tab maybe. Thanks Rich

Hi. I have a file with data on two separate worksheets. They need to stay on separate worksheets. But I need to print both worksheets on a single page, without scaling either. They're not large, they will both fit onto a single sheet without scaling. I did an internet search, my friend...

I have created a one page "form" with an Excel worksheet of my work computer. It is designed in a manner to be previewed and printed on one page without any scaling. When I take this same worksheet home and edit it, preview or print, it no longer fits within the one page originally created to...

Is there any way to scale UserForm according to screen scaling? This code works for screen resolution, but it does not recognize screen scaling: With Me .StartUpPosition = 1 .Width = Application.Width * 0.85 .Height = Application.Height * 0.85 .Left =...

Hi Mrexcel I'd like to scale columns of number to be TOP=100 BOTTOM = 0 Is there an easy way? Thxs <tbody> 113 99 118 84 TOP 100 5 9 -8 16 BOTTOM 0 </tbody>

I have a question that I am not sure can be described proper (From my viewpoint) to make sense for an answer; however, I will give it a try: I have an issue with a new family venture that is calling for a simplified method to scale up recipes for use, and I wish to remove as much human error as...

Hello, how can I change Excel's printer settings so that every time I open a new workbook, the settings to print are always set to Landscape and the scaling is always set to Fit All Columns on One Page? I'm using Excel 2010. Please help, thanks.

Hi, I am trying to create VBA code that formats the y-axis labels of 10+ charts as ##B , ##M , ##k depending on the size of the data being plotted. Is there a way to set a VBA variable equal to the height (max value or sum of values) of the "tallest" data point, whether it is the highest value...

I'm currently recording a macro to to read a .txt file apply, then a function will be applied to the data and then graph it. However excel's x-axis scaling isn't as friendly to use as it appears. I need my data to begin being read at 100 centimeters but I only want the x axis to show spacing...

Kind of a wierd concept, I can appreciate that. But, what I'm look for is to do with grades. For example, one exam is worth 10% of the year and you scored 80/100 and a 2nd exam is worth 40% of the year and you scored 75/100. You haven't done the rest of the exams worth the remaining 50% of the...

Hi, I have been looking at the automatic scaling properties of charts in Excel and based on this article - How Excel Calculates Automatic Chart Axis Limits - Peltier Tech Blog - plus my own testing, I have found that the automatic ranges are set to: The maximum value is Ymax + (Ymax - Ymin)/20...

In my workplace, we have these excel templates for our reports on our network . These templates have been used for years with no problems. Recently, a coworker who had just gotten a new computer has had scaling issues with these excel templates. The images in her header and footer were about 75%...

Is there anyway I can make excel scale a set amount of information between page breaks fit 1 page wide 1 page tall? using a macro. <tbody> FT000010 SPAX SCREWS 1000pc TRADE PACK Llandeilo 4 0 0 0.1725 2 6 FT000010 SPAX SCREWS 1000pc TRADE PACK Ammanford 0 0 0 0.0515 0 1 FT000010 SPAX...

Hi all, I have quite a few graphs on my spreadsheet and i'd like to have the axis scale change according to the data. For instance, when I have a graph with values between 6-10 i dont want scaling from 1 to 100. Any tips??

I have a spreadsheet that comes up with the page break every cell error when I run macros that touch any of the page layout or print parameters. My understanding is that this an error that sometimes occurs when Page Scaling is used. Has someone come up with a short sweet workaround code that...

Hello, I have a recipe that uses for example, 3 cup flour 2 cup sugar 3 cups milk 4 eggs And this produces 18 muffins. Are there formulas I could use in excel to scale the recipe up or down automatically? Meaning if I wanted to produce 30 muffins. Could it automatically change the...