Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Deepak Thakkar
 
Posts: n/a
Default 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

  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

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 ?


  #3   Report Post  
Deepak Thakkar
 
Posts: n/a
Default


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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a combination graph with stackedColumns+lineGraph ChartQuestion Charts and Charting in Excel 1 June 14th 05 12:39 PM
Graph Help- 12 month graph, but only want months that have passed coal_miner Charts and Charting in Excel 4 June 3rd 05 03:03 PM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM
how do you split the scale (x-axis) on a curve graph? valeval1000 Charts and Charting in Excel 1 January 11th 05 01:18 PM
Graph Axes Robin Excel Discussion (Misc queries) 0 December 8th 04 08:03 PM


All times are GMT +1. The time now is 02:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"