Forum Discussion
Chart demonstrating ranking
I am trying to plot some data on a chart to show the trends of how popular programmes have been over the past three years, I have the ranking of those in the top twenty across the university (only so...
Please find the attached with a sample chart for a simple data set.
I inserted a helper column which replaced the actual series (Actual Rank Column) and to do so, right click on Chart and choose Select Data and in there edit the existing series with the helper column.
And then format the data labels and choose Value From Cells and select the actual rank data.
See if you can incorporate this approach to your chart.