Click on a chart axis, then Format-Selected Axis...

Under the "Scale" tab, tick "Values in reverse order"

HTH,
Ryan

"Chris" wrote:

I looked through all the chart options, where do you see it?

"Marcelo" wrote:

Hi Chris, you could switch this in chart options

HTH
Regards from Brazil
Marcelo


"Chris" escreveu:

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?