It looks like this was possible in earlier versions of Excel by having a Bins column on the same worksheet with the data. The bin sizes that are automatically chosen don't suit me, and I'm trying to determine how to manually set the bin sizes/boundaries. With a bit of trickery, it is possible to create this chart age range - frequency - central band width - bin width - height (respectively) 1-4 - 30 - 2.5 - 3 - 10 5-6 - 20 - 5.5 - 1 - 20 7-17 - 30 - 12 - 10 - 3 With age along the X axis, with a linear scale, so the bin width for 1-4 would be 3, with height 10, bin width for 5-6 would be 1 with height of 20, and 7-17 would be 10 and the height would be 3 I'm trying to create a histogram in Excel 2016. However, it is possible to get creative with a stacked area chart and the correct data layout. Excel does not have any settings to change the width of individual columns when using a column chart. This same principle of column width also applies to histograms. For example, where each column represents different ranges of data. The options to modify the bins will be available under the histogram tab in the Format Data Series panel on the right However, in some circumstances, it would be better for the width of each column to be different. Re: How to change bin number/width in a histogram in Excel for Mac (Office 2020) Found the answer: Select your histogram chart by clicking on one of the bins. Home Excel histogram different bin widths
0 Comments
Leave a Reply. |