Pie chart using data from two columns

The pie chart reads data vertically (row-by-row), whilst you are trying to read it horizontally (column-by-column).

I would suggest looking into Quickchart.