Data Anaylsis Toolpak; Histograms

[hotwired]

I am trying to create a histogram however I have hit a snag. My data looks like:

Tons D50
234 54
2343 150
45 300
....

As you can see a simple histogram would see three and show it as such. However that doesn't do it justice as 150 has alot more tons then the others. So is there a way for it to use the tons as the frequencies? Thanks.

[Andy Pope]

Do you think you should multiple Tons by D50 and chart that instead?

[hotwired]

No that would start along the lines of a wieghted average. I gave up and just wrote a macro to sort the data for me. Thanks anyways guys.