Reversed Y-axis charts in Excel 2007
I had an unusual query this week. A member of staff wanted to create a line graph that showed the chart position of a song over a number of weeks.¬¨‚Ć It’s an easy thing to do – two columns in the spreadsheet, one for “Week” and one for “Position”. Problem is, in a chart, the low numbers are at the top and the high numbers are at the bottom, so the graph comes out upside-down. You can’t just make the …