In Numbers, instead of equally sized bins (column bars) how can I create a histogram with variable sized bins?
Here's an example set of data. As you can see, the value in 'Bin Width' varies.
How can I create a histogram where each bar's width is determined by the value in Bin Width?
iPad Air, iPadOS 26
If you are talking about creating a chart from the data, it is not possible to create a column chart that has columns of various widths. They are all the same width.
What do you mean by 'variable sized bins'?
It isn't clear what you're hoping this chart will look like.
If you're trying to change the width of a column on a bar chart, there's no support for that - all bars will be the same. If there's something else you're trying to do, please post more information and we can dig deeper.
For example, I've created a random table of 100 people's ages. Just the same as the demographic polls you get with products you would buy.
One table contains the age ranges and the quantity of responses in each range. As you'll notice, each range isn't uniform. So, each histogram cell should have a different width to reflect the size of the age range.
As you can see, each age range has a different amount. So, each bin width is also.
Now, to accurately reflect each age range's size, each histogram column would have a width relative to each age range.
That varying bin width of each histogram column should be in proportion to each range.
The checkbox is a clever trick I put in to force a recalculation of first, new random ages in the Rand # column which then recalculates the Frequency of each range.
These pictures should help explain.
Create a histogram with variable bin widths in Numbers
