I am writing a macro that finds the prime numbers between to numbers chosen by the user. I want to create a histogram showing the distribution of the primes. I was going to use the Histogram tool in the Data Analysis add-in. My problem is in setting the input range. I do not know how many entries there will be in the input range. How can I write the argument so that it can be "dynamic" I can determine how many entries there are after I determine the prime numbers but I am not sure how to put that info into the Histogram argument.
I have been searching to see if it's possible to create a histogram with non-numerical data and it doesn't seem like it's possible. Is there something similar where I can. Count number of occurrences of a string and organize them from most frequent to less frequent? There are about 60 possible strings.
e.g. ABCDEFGHIJ 1ddhykygghd 2jlqqwertya 3ukhghjklzx 4tukyuuiioa 5xypyjkkadh
Then output the counts of each of the strings (letters in this case) present. I was thinking of just putting them in the same row or column and manually counting, but it doesn't seem like it would be that difficult have it automated.
I'm trying to make a histogram with the data analysis tool. The problem is that whenever I make a chart it doesnt show my intervals correctly. It puts them under the bars instead of between them.
I'm making use of a histogram to visualize my data. The only problem is that 90% of the data has a value which lies close to eachother but 10% is very different.
I'm trying to use the 2007 histogram tool (or frequency) to show me the frequency of data, but my data is in a different form than required for either of these tools. Let me use the following simple case -- to show the frequency of student grades both tools assume I have a list of student's test grades. What if I instead have more than one column, e.g., "grade" and "number students with that grade"??
My application is actually different, but it's still 2 columns, a numeric property and a weighting factor (e.g., fraction of the total).
On Histogram, is it possible to plot Bin averages?
In my data there are two columns, 1) File Size 2) Months and then I have created Bin(months) like 0,6,12,18,24
I want to plot average file size in those Bins. For example I would like to plot what was the average file size in past 6 months, past 6-12 months so on.
I've been trying to make this work with Chart Wizard and can't. I gave out 331 surveys and the data in each column is the answer selections for each question on the survey - A,B,C,D,E. I'd like to do a histogram for each column simply with the percentage of people that chose each answer selection.
I have a large table (20,000 plus entries) and I need a way to pull out data that matches criteria in buckets.
For example: April data (column B) that is from 0 to 30 (column C) April data (column B) that is from 31 to 45 (column C) ... 46 to 60 ... 61 to 75 ... 75 to infiniti
Then do it again for May, June, July, etc. I have used DCOUNTs to pull this type of data, but it's a bit cumbersome. Any other ways to pull this type of data from the table?
I am looking for an formula to calculate the bin width for a histogram chart.
I am thinking of creating 50 bins for the chart. The range (max - min) of the data can be from £10 to £5,000,000.
A straighforward formula will be (max - min)/ 50. But I don't want decimal point in the bin numbers.
I am thinking of using Floor/Ceiling function, to round the bin-width to whole numbers, but 10/50, 100/50, 1000/50,..., 1000000/50 all need to round up/down to different scales! for example, I want 100/50 round to 5, 1000/50 round to 50 etc.....I was wondering is there a formula I can use to calculate the bin-width based on the criteria above or similar?
Those "False, False, False, False" parameters to run a histogram, whatever do they mean? Application.Run "ATPVBAEN.XLAM!Histogram", Range("Inputs"), Hist.Offset(0, 3), Worksheets("OutputSheet").Range("Outputs"), False, False, False, False
Through recorded code, I've seen that to create a histogram, the third False is a "True"... but let's say I've already got the blank histogram created. I'm running a simulation (where the inputs range is being updated with every run), and I want the histogram to be filled in at the end of all the runs. What do these parameters have to do with it? Having them all as false, like I've been told, isn't working.
We were working on a set of stock returns using histogram option from the analysis tools. We have not been able to figure out why we have produced two different sets of frequencies over same set of data and one predefined bin range.
Only a few classes present different counts. Can this be due to two different versions of excel were used?
I'm trying to come up with a histogram chart that adjusts Bin Size based on user input. I've come up with the formulas for Bins and Frequency, but am struggling when it comes to charting the data to dynamically update when the user changes Bin Size. How to make the x-axis dynamically adjust with the number of Bins.
i m given 12 max value of my 292 cells. now im asked to find number of cells that falls within each of these max values?? im asked t use histogram. how will i do it?
I have an issue creating a PDF of more than one sheet. Only top left corner of sheets are shown in PDF. Creating a PDF of a single sheet works perfectly. I have attached the result (2 pdf-files) and the original Excelfile.
I am unsure if this is supposed to be in the PivotTable or VB section, but given it is VB code I expect here is better.
[Code] ......
I can confirm the SourceData exists, and can be used to create a pivot table without error. Only when I try to RUN this code does it kick out saying, "Invalid procedure call or argument".
I am tying to build a macro that contains a function to open a closed workbook, create a new tab, select the tab and then paste data into it before closing the workbook.
In a separate macro I will then want to open the workbook again and compare the last two tabs worth of data, to highlight where old data has been removed.
I'd like to create a search bar where someone types text into a field in Sheet1 (in the sample B1), then clicks a macro button to search for that word in Sheet2.
The result should be that the cell containing that word is where you end up.
The search word shouldn't be an exact match for the result, the cell just needs to contain it.
The search bar should also be present on Sheet2, with an additional button for Find Next, so that the user can move to the next result if the first one is not what they're looking for.
I've managed to create a search function with a pop up box using the below but this isnt as effective.
I'm trying to make a macro that creates a button (to run another macro). I'm also trying to make sure this has a specific name, instead of just "Button#". The code I get from recording this is:
On a worksheet i have a list of names in Column A the list length can vary this is why i want to create a userform using VBA. The form just wants a checkbox with name next to it for each name in column A. If the checkbox is ticked I want a 'Y' in Column B next to the corresponding name.
I have wriiten some simple code to create a chart which works fine. I have a problem applying formatting to my chart. I am using the With construct to apply the formatting, but the problem is that the chart name keeps on incrementing from "Chart 1" to Chart 23" etc. each time I run the chart and I get an error message before the With code?
I have a workbook which uses the code below to create a new menu upon opening. I have now used this same code in a second workbook to create a different menu. both work OK on their own However if by chance both workbooks are opened at the same time only one menu is shown. Is there a way I can change one of these to create a second menu if the first one is already there?
I thought this would be a simple task, but i cant seem to figure out how to do this. I have a list with names and its a fixed number of rows, say A1:A200. In the next column, B1:B200, there is either TRUE or FALSE. I want a make a new list with all names with "TRUE" on the same row, without any blanks. How can I do this?