There are quite a few variables your described question that depending on how your data is set up may lead to several different ways of doing this. Would it be possible to post a sample workbook (twbx file)?
Thanks for the reply. I have added an Excel file outlining what I am trying to achieve and showing the steps I go through to achieve the graph in Excel from the underlying data. I hope this helps as I am not upto speed on twbx files. Just starting off with tableau.
You can create a .twbx file by going to File->Export Packaged Workbook. This creates a Tableau workbook that has the data packaged within it.
For the view you wanted to create, the data was not optimally shaped as the Year is really a dimension and not a separate measure. I used the Tableau Data Reshaper add-in for Excel for this. There's more info on shaping data at http://kb.tableausoftware.com/articles/knowledgebase/preparing-excel-files-analysis, with a link to the reshaper.
The calculation you used to bin the data in Excel was a variation of a ceiling function, since Tableau doesn't have one native I built one, using ideas from here: http://community.tableau.com/thread/111530. Tableau's built-in bins use the next-lower value, and aren't able to be used in calculated fields (which is necessary to generate the grouped bars), so that's why I didn't use those.
Finally, to generate a grouped bar chart in Tableau we have to appropriately assign the Y axis values for each bar. The basic method is outlined in http://kb.tableausoftware.com/articles/knowledgebase/grouped-bar-chart.
See the attached, the last two worksheets were created using Tableau's built-in bins as an example.
grouped histogram.twbx.zip 82.1 KB