LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default problems with .Crosses and .CrossesAt


hi there,

i'm in trouble again :)

I am designing a Chart with x-axis values going from -430 up to +43
and y-axis values going from -2.0E-02 up to 1.8E-02.


I'd like the axes to cross at their minimum (so point -430 (x-axis) an
-2.0E-02 (y-axis) to be the crossing). (default they cross at point 0.0
-430)

I tried everything with .Crosses = xlMinimum or xlMaximum, obtainin
all the possible crossings, but the one I need.

Of course I could just set the .CrossesAt property at the minimu
value, but I am generating dynamically many charts and th
minimum/maximum values are not always the same.


Th

--
Ciccio_Drin
-----------------------------------------------------------------------
Ciccio_Drink's Profile: http://www.excelforum.com/member.php...fo&userid=3100
View this thread: http://www.excelforum.com/showthread.php?threadid=50764

 
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
Setting x-axis crosses with VBA Robert H Charts and Charting in Excel 2 December 14th 08 03:55 PM
Should allow: "Value (X) axis crosses at *-MINIMUM-* value Chadillac Charts and Charting in Excel 1 August 8th 06 12:39 AM
Value (Y) axis crosses between dates Frager Charts and Charting in Excel 2 January 17th 06 11:13 PM
ActiveChart.Axes(xlValue).Crosses = xlMinimum Stacy35216[_4_] Excel Programming 4 August 17th 05 03:51 PM
Ticks or Crosses Gary T Excel Worksheet Functions 2 June 1st 05 12:04 AM


All times are GMT +1. The time now is 06:28 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"