1. J

    Rotate histogram graph

    Hello does anyone know how to rotate a histogram graph 90 deg Thank you
  2. J

    Histogram graph

    Hello We use a product that generates an histogram on a PDF I would like to generate a mirror image of the report but I also need help to generate an histogram graph. How can I show you how the reports looks as I can't post images
  3. C

    Start histogram Bins at 0

    I am trying to do a histogram in excel with the bins starting at 0 and each Bin being 0.2 in width. However when i set the bin width at 0.2 it starts the first bin at 0.11 because that is the lowest number in the dataset. how do i get the bin to start at 0 so that that the bins are...
  4. F

    Frequency Distribution of streaks

    Hello, I need the frequency distribution of streaks like 0 -1 -1 -> 2 0 0 -1 -1 -1 -> 3 0 Is there a way to create a column like column 2 in excel so that I can create a histogram that shows the data. Thanks for any help.
  5. S


    Can someone explain me how to create histograms with the Data analysis option when I have large data? Thank you.
  6. N

    histogram / bar chart out of string values?

    Hi, I have large list of words which are repeating and I would like to make a nice histogram out of it. However, when I try I am not able to do it as it says - input values are not numbers. I know how to solve this by creating two extra collumns, but I need to link data to the chart, as I am...
  7. M

    Histogram formula when bin selection is based on cell value rather than measure

    I'm OK with using measures to assign which bin of a histogram an item should go but I'm having an awful time figuring out how to do it when the column value itself is what determines a bin. Assume there is a Histogram table with 3 columns of bin label, max val, and min val. My data table has a...
  8. J

    Excel historgram question

    Hi All, I'm making an Excel histogram with 100 bins. I don't want 100 labels for the bin values, however. How can I limit the number of labels on the bins (i.e. have 100 bins but only 5 value labels)? Thank you!
  9. N

    Create histogram for continuous data

    Hi all, Anyone know how to create a histogram for continuous data? I want an x axis that begins at 0, then half a unit to the right i need it to start at 150 and finish at 200 at 10 unit intervals (classes). Between each of these 10 unit intervals must be a column (no gaps between columns)...
  10. M

    Histogram Bins

    I have a set of data that I would like to create bins. For example, 45, 23, and 10 will fall in the 0-49 bin. I created the histogram but am struggling in changing the ranges to display as the bins as the ranges below.:confused: Data: 45 23 897 456 123 10 Bins 0 - 49 50 - 99 100 - 175 176 -...
  11. B

    How do you modify the widths of the bars in a histogram that has unequal intervals

    I have created a histogram for data that is collected in unequal intervals (grouped data). I determined the frequencies and used the bar chart. I want to change the widths of some of the bars to different widths. I can find the following -- I click on one of the bars and it shows a width on the...
  12. R

    Bell Curve Histogram with 3 sigma line

    I have been asked to add a 3 sigma to the Fire and Release. The problem is I have no clue how. If you could please help me out that would be awesome! Thanks soooooo much Test stats..xlsx - Google Drive
  13. V

    How to group employee experience numbers 11.03, 0.11, 10.00 in pivot table and then it should get the count

    Hi i have a sheet with column Total Experience and all these numbers are as follows. 11.03, 0.1,0.11. So my boss wants to know the count of the members as 0-2 years experience how many members, 2-5 years experience how many members, 5-8 years experience how many members,8-10 years experience how...
  14. S

    Dynamic bins for mulitple data sets

    Hi Everyone, I'm not that technical and I'm hoping someone wouldn't mind helping. I have multiple data sets which vary both in range (lower and upper bounds?). Each data set will also change for each new scenario, for example on any given date Set 1 might have a range of -4 to +4 and the next...
  15. T

    Histograms - StdDev help

    Hi, I am hoping you can help. I am trying to display my information as a histogram using Std Dev. I can get the curve correct but I am having trouble with the labeling of the axis. The X axis is showing values which I did not want. What I want is to show each bin on the X axis and the...
  16. M

    Frequency * Time histogram data

    Hi, I have searched far and wide for a solution to this and spent hours trying to figure it out, and I am now admiting defeat and hoping someone will be able to help me. I have the following type of data: Example dataset: <tbody> A B C D E 1 Level Time Bin Range Level Frequency Level...
  17. WaqasTariq

    Using Macro: Find optimal bin size for data pasted by user to create a histogram

    I am trying to find a way to create optimal bin size for the data (random size/rows - based on user input) provided by user to create a histogram. The data has random times within a 24 hour time period along with varying quantities. I did find two methods online, but they had issues; The...
  18. J

    Please Need to have an Idea

    I'm required to build a 'weather station' in Excel that brings in the daily rainfall for a Bureau of Meteorology weather station selected by the user. You must give the user at least three options of weather stations to choose from including Nambour. Also make sure that as other stations are...
  19. R

    Creating Histogram by Classification

    I want to create a histogram by classification that will update when I add new values. So say I have a classification of A, B, C, D And numbers that correlate such as A - 200 A - 140 B - 34 B - 56 C- 100 etc... (There is lots of these) How can I make a histogram that will be like... Of all...
  20. J

    VBA/ Macros Conditional formatting Bar graph

    Im wondering if anyone can help me im looking to make a large number of histograms change colour depending on the bar value. If the value is below 0 (<0) I need the bar to be green RBG (0,255,0) if the value is above 0 (>0) i need the bar to change red RBG (255,0,0) Does anyone have any ideas...

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