Pivot Chart

I had problems exporting the Pivot Table to Excel, it turned out like this:

Sheet 1

(the pull-down menus didn’t transfer correctly)

Sheet 2

Pivot_Table_01_Salary_vs_Location

Here’s what it looked like before I tried exporting it:

Data Sheet View