How to get a Column Series into Rows Series in a Chart
I have data like the below table. Years are as column headers corresponding to City.
| City | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 |
| Chennai | 12.5 | 22.5 | 34 | 23 | 36 | 39 | 45 |
| Bangalore | 23.6 | 24.8 | 30 | 34 | 34 | 38 | 49 |
| Vizag | 13.9 | 23.9 | 20 | 43 | 45 | 40 | 44 |
| Hyderabad | 34.8 | 44.8 | 39 | 23 | 36 | 38 | 39 |
| Kerala | 14.8 | 56.8 | 44 | 23 | 22 | 29 | 34 |
| Mumbai | 8.5 | 43.9 | 34 | 29 | 34 | 38 | 31 |
| Delhi | 25.7 | 24.8 | 30 | 27 | 28 | 35 | 43 |
Required output as follows. I did this in excel.
Can you suggest me how to design the data.
Thanks,
Ram Reddy