Switch Row/Column

To show your columns as the category axis and your rows as the legend, navigate to data settings and check Switch Row/Column.

Before:

After: