| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting x axis scale to time with variable intervals | Charts and Charting in Excel | |||
| can't change how data on 2nd axis is being displayed | Charts and Charting in Excel | |||
| Show quarters and years on x axis of a chart | Charts and Charting in Excel | |||
| Second X axis at top of chart? | Charts and Charting in Excel | |||
| Graphing Reversing the Axis | Setting up and Configuration of Excel | |||
Threaded Mode
