Usually I'm pretty good with Excel, but I'm trying to do something that my mind says should be easy and just can't figure it out. Either it can't be done or both my MS application and Google skills have deserted me on the same day (maybe due to insufficient caffeine intake so far).
So... I have an Excel 2013 spreadsheet that stores some data, and there are calculations done on data values to come up with a ranking that's updated at regular intervals. For business reasons I can't discuss the actual data, but here's a good analogy:
Say the data is a series of sales figures (orders, customers, items, dollar value) and some weighting is applied to these, for example signing up new customers or selling a small number of certain strategic products is seen as more important than taking orders from existing customers or selling a high number of low-value products. Sales data gets entered into the sheet and Excel counts orders, sums dollar values, applies weighting criteria, etc. One minor part of the process is that a small table on it's own tab calculates a rank for each salesperson to show who has been the most successful that month, and the table is sorted by ranking.
Here's a sample of what that table might look like, and a chart created from that table (click for the enlarged version):
What I want to do is change how the chart is displayed so that the people's names are shown as the labels on the Y axis, instead of them appearing in the legend and the ranking appearing on the axis. It's probably really simple, but I can't seem to get Excel to do this for me.
EDIT: I just noticed that in the sample I mocked up, the Y axis is in the incorrect order - it should be in reverse order so "1" is at the top, but ignore that - it doesn't affect the issue I'm having.