How do I rotate the X and Y axis on a bar chart?

I can manually transpose the data table with paste special-transpose, but is there a quicker way that does not require creating another data table?

My data is a 10 by 12 matrix of temperature and percipatation for major cities.I need the Temperature readings (on the x axis now) to be on the Y axis.

* The Switch Row/Column does not accomplish what I want. Because it changes the key/legend.