Jan 03 2019 12:17 PM
Hi,
I have my histogram inserted and setup with 4 bins grouped into a width of 20. The issue is that the groupings of 20 do not start and end on the numbers I want them to. For example, the first bin excel created has the range of 146 - 166 while I need to count numbers in between 140 - 160. Please see the attached file for reference. Please help. Thank you.
Jan 03 2019 01:05 PM
Hello,
insert a pivot chart with grouping starting at 140 and ending at 220 by 20.
Jan 03 2019 01:14 PM
Hello,
The histogram chart only works with existing values. The lowest value is 147, so that will be the start of the first bin. If you want the bin to start with 140 you need to change the lowest data point to 140.
Jan 03 2019 02:14 PM
Jan 03 2019 02:14 PM
Jan 03 2019 02:35 PM - edited Jan 03 2019 02:37 PM
I realize it will change the data set, but in chart preparation we often have to use these kinds of tricks to arrive at a desired chart. Since the histogram has no setting to define individual bin start points, manipulating the source data is the only way to go.
If you want to use a pivot chart instead, follow these steps:
let me know if that helps