histogram

My goal: I will have 5 sheets with 5 different sets of data and bins on each sheet. I will also be including a lined scatter plot and a histogram graph of each set of data on each sheet (25 total). I want to only have the histogram chart visible on each sheet (i.e, I don't want my sheet to have...

Hello found a pretty neat tutorial on how to create a 3d histogram in excel here. Advanced Graphs Using Excel : 3D-histogram in Excel Making the 3d histogram works fine but I would be able to colour the 3D boxes according to a third variable. Currently I just have a matrix where the values in...

I need to create 50 histograms, so I recorded a macro that creates 1 histogram. The code is this: <code style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans...

Hello Everyone! I’m aware of a few types of histograms. I'm aware that Excel supports a standard "frequency histogram" via DATA > DATA ANALYSIS > HISTOGRAM. The is the simplest kind, in that the height of the bar is the # of outcomes that fall within the “bin”. A slightly more sophisticated...

Hi, I've been battling with this for some weeks now and everytime I seem to have solved it, I find it comes back x weeks later. Scenario: I have a list of 8760 values (the number of hours in a year) which vary from around -9 to +32. However these values are dependent on other things in the...

I'm trying to make a histogram on excel, but I can't make it so that the x axis represents the labels -- in my case, the change in values -- and make the y axis represent the the number of times those values occur. In other words, let's say I have the values: 30,40,40,30,30,40,30,80,80,80 How...

I am trying to use a macro to make a histogram. I have a randomly generated array of numbers that I would like to make a new histogram (actually two histograms) with every time I re-calculate them. I don't mind having to press a button to make the macro go, but I don't want to have to enter...

Dear Experts, Note: I'm using Excel 97. That's right. I have a huge set of data with a wide range of values. About 800 rows. One column. 0 1 24 56 75 2 8 45678 2 98 33356 32 etc. I'd like to make the table that you need to make the histogram. With counts in the appropriate cells...

Hi, I am trying to make use of the histogram add-in in a macro but it errors out saying "Run-time error '1004':", here is the code. Application.Run "ATPVBAEN.XLAM!Histogram", ActiveSheet.Range("B2:B17") _ , ActiveSheet.Range("I1"), ActiveSheet.Range("E1:E24"), False, False _ , False, False I...

Hello, I'm writing a code that calculates a histogram on a series of pages in my Excel workbook. The histogram data replaces a preexisting calculated histogram. I can't seem to get my code to ignore the popup box that says Output range will overwrite existing data. Press OK to overwrite...

I need a to keep an accurate count of my inventory. I built a detailed excel program, But it only works when I fill in every column. For instance. Column 1 is Amount sold, which is done every date, column 2 and 3 is Loose and Cooler, which is a physical count. Column 4 is Supplied, which is done...

I have a histogram question. I have a bunch of different schools and grades within schools that I want to make histograms for. I know how to make a histogram for each school by grade but I have 8 different grades and 21 schools. How do I do this efficiently? In Stata I can do this through a...

Hey everyone, I have what should be a fairly simple problem that has been taking me forever to figure out. Here is my situation (Using Excel 07): I'm going to be inputting 100 numbers into a column (Say B2:B101) and need to make a histogram out of that at intervals of 1 from the lower bound to...

Hi!! I'm using histogram to calculate number of flight departures in an hour interval,so the bin range i use is from 00:00 to 23:00 and input range as the dep times,why do i receive value "More" in the output after 23:00Hrs values? Is it because these are the values between 23:00Hrs and 00:00Hrs...

Hello all! I hope this isn't one of those forever re-posted questions, but I have spent a couple of days looking over the archives on this site, as well as experimenting with Excel 2007, and am coming up a bit short. Simply put, I would like to take a column of date/time strings, for example...

I have been googling this to no avail: How can I put multiple histograms on a single chart without having all of the bins (i.e., the x-axis values) being the same? This is easy to do with the XY Scatter Plot format (I mean letting all of the plots have their own range of X values), but I can't...

Why do I have More with a number in the results? How do I get rid of the More and number? Without having to delete and resort. Thanks for your help in advance.

Heya, I'm trying to make an histogram, but I get totally lost when they ask me to define BIN-numbers. I understand these are the limits between which you wanna count the data. E.g. if I have the numbers 3.8, 4.3, 4.2, 5.1, 5.5, 5.3, 7.1 and the following BIN numbers: 4 5 6 7, I'll find a...

I am looking to create a chart detailing the distribution of an equation that has a random number generator as a component. So, the end result would be the above mentioned equation showing a normal distribution curve (or some other distribution curve - not sure yet!!). Here is the catch...

Hi there, I am trying to use Excel to generate a histogram for the ages of managers from Urban Child Care Centres. I have 50 different ages and I want the bin cut-off points to be 30,40,50,60,70. When I try to generate frequencies using the frequency function, or to generate a histogram using...