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.