ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Graph on Inverted Scale (https://www.excelbanter.com/charts-charting-excel/36894-graph-inverted-scale.html)

Deepak Thakkar

Graph on Inverted Scale
 

hi,

Can we draw an excel graph on an inverted scale ?


--
Deepak Thakkar
------------------------------------------------------------------------
Deepak Thakkar's Profile: http://www.excelforum.com/member.php...o&userid=25560
View this thread: http://www.excelforum.com/showthread...hreadid=389936


Jon Peltier

Do you mean in reverse order? Double click the axis, and check the
Values|Categories in Reverse Order box (and probably also the Axis
Crosses at Maximum box).

Do you mean plot vs. 1/x? Try this:

http://peltiertech.com/Excel/Charts/RecipAxisChart.html

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


Deepak Thakkar wrote:

hi,

Can we draw an excel graph on an inverted scale ?



Deepak Thakkar


thanx Jon .. values in reverse order worked.

thanx again for the help


--
Deepak Thakkar
------------------------------------------------------------------------
Deepak Thakkar's Profile: http://www.excelforum.com/member.php...o&userid=25560
View this thread: http://www.excelforum.com/showthread...hreadid=389936



All times are GMT +1. The time now is 09:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com