I am looking to map out several customers' credit scores on a line graph. The credit score will be on the x axis and the count of customers will be on the y axis. Since there are so many possible credit scores, the line graph looks very jagged. I was able to make it look smoother by rounding all of the credit scores to the nearest 10th, so if the score is 778 it rounds to 780. Although this made the graph look the way I needed it to, the values on the y axis were inflated because of more customers falling into each rounded bucket. Is there a way for me to replicate what I did by rounding while keeping the y axis the same as before rounding?
If the chart is telling the truth then we must have some respect for what it shows us. However here are a couple of suggestions:
You can increase the size of the classes, that should help to even out the peaks and troughs.
If you think the users would be able to properly interpret it in the Axes tab of the chart you could change your expression axis to a Log Scale and check the Show Grid option. That will make the highs and lows look less extreme but your audience will need to be made clear that the scale is not linear - a bar twice the height of another represents a ratio of 10:1.