Is there a way I could invert a series on a graph? Lets say my data points
are 3,9,2,4,7, but I really want graphed 7,4,2,9,3. Is there a way I could
just switch this in chart options? Here's the complicated part, a simple
solution would be to just invert the numbers in the worksheet using the index
function. However, I'm trying to record a macro and it seems impossible to do
if I use the index function because for different groups of data I'm not sure
what my last cell number will be. Any help?