Go to MyExcelTools.com  
Excel Categories Chart    
With Excel Categories chart may show data by categories
In the first row Categories
In the last row Bottom Line
In the penultimate row Top Line
Select the range with the data (Red Border)
Select Where to paste the Excel chart
Finally press the OK button to insert the chart.