8

I'm charting the frequency of a range of numbers in a histogram in Excel 365. The numbers range from 236 to 1736 and I've got the bins at 250. Excel is automatically starting the histogram bins at the 236-486 range. I don't see an option anywhere to make it start at 0-250. Can anyone help me change it?

Formatting options:

formatting options

What I want it to look like:

What I want it to look like

The above was created in a different program that I have access to only through my school, using the same set of data. I'm trying to figure out how to do it in Excel because that's what I use in real life.

Here are a subset of my input data and the chart I get now:

Data

(Ignore Columns A and B.  Columns Y and Z represent the frequencies of the numbers in Column M; e.g., there are two values between 0 and 250, four values between 250 and 500, and so on.)

Scott - Слава Україні
  • 22,532
Kay
  • 81

4 Answers4

10

Set 'Underflow bin' to 250. The first bin will be '<250' and the rest in 250 increments as needed.

Craig
  • 101
2

You could set the "number range" for different X-Axis Labels first, and set the Bins as By Category. Then you could try to change the labels on X-Axis by change the Data Source. But you need to make sure the counts of "Frequency" correspond to these labels. Hope this workaround could help you~ enter image description here

Emily
  • 4,035
-1

If you're in a hurry, cheat: change one of the values in the first bin to a 0.

franzo
  • 117
-2

If you turn underflow bin on and set it to 0, the chart will start there. I don't remember if it skips multiple empty bins or shows them all, I'll have to check at the office, but data should always start on a multiple of the range + the underflow value.

SilverbackNet
  • 1,085