View Single Post
  #3   Report Post  
Jon Peltier
 
Posts: n/a
Default

If you're not happy with a line chart, double click on the axis, and on
the Scale tab, check the Values in Reverse Order box, and perhaps also
the Value Axis Crosses at Maximum Value.

If it is a Line chart, and you don't want to sort the worksheet,
double click on the axis, and on the Scale tab, check the Categories in
Reverse Order box, and perhaps also the Value Axis Crosses at Maximum
Category.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Bernard Liengme wrote:

Would you be happy with a Line chart (rather than XY)?
If so, put 20000 values first, and 0 value at end of column; make Line chart
best wishes