Not sure how to build this bell-curve chart

Here is problem I'm trying to solve. It's for logistics company. I got all other inputs/variations take开发者_运维百科n care of so I have 1 straight-forward thing to do.

There is table with historical orders and prices paid per/mile. I need to present/visualize pricing distribution. Let's say prices vary from 0.80 to 1.80 per mile. Most loads done at around 1.40 per mile.

There is no special requirement HOW I should visualize that but the way I see it - X axis will show price Y axis will show loads count I will show it as a curved line.

To make it look nice - I probably need to aggregate gata into 5c buckets so I don't have many points on X axis.

Does it sound right? I don't want' to reinvent wheel and maybe there is built-in function to take care of all that in 4.0 chart control?

Thanks in advance.

The MSCharting samples has a "HistogramChartHelper" utility class that can make histograms easier. I copied and made some minor edits to use in my project.

Your methodology sounds good to me. Aggregating things into buckets can definitely help to drive the point home ... just don't hesitate to play with the bucket sizes as an arbitrary 5c might not be the "right" size. I would also recommend giving the old bar charts a try ... depending on how many data points you have, I find it sometimes just looks better as a series of bar charts :-)