Hi,

Use a different set of cells for your chart data.
You can use formula to reverse the order of the data.

Assuming chart data, labels and values, in A2:B6. Use this formula in E2

=INDEX($A$2:$B$6,ROW($6:$6)-ROW()+1,COLUMN()-COLUMN($E:$E)+1)

copy across and down range E2:F6

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"AAT@MCMLP" wrote in message
...
My data is sorted descending and I want to keep it that way, how can I
sort
my chart into ascending without resorting my data to desending order? Thx
for
the help.
--
___________
AAT@MCMLP