Forum Discussion
Histogram Bins Issue
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 fir...
Hi,
If I add a lower data point it will alter the data set. Please advise.
If I add a lower data point it will alter the data set. Please advise.
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:
- Select the data from B4 to B14 and click Insert > Pivot Chart
- drag the Data field into the rows area and again into the values area
- In the values area, change the value field settings from Sum to Count
- select a cell in the first column of pivot table that feeds the chart, right click and select "Group"
- set the option to "Starting at" 140 and "By" to 20, leave ending at blank
let me know if that helps