Column with categories
 
 
With Excel Categories chart may show data by columns and groups of categories:
-In the first row Categories
-In the last row Bottom Line
-In the penultimate row Top Line

You must select the data as it is shown in the example.