Go Back  Xtreme Visual Basic Talk > Legacy Visual Basic (VB 4/5/6) > VBA / Office Integration > Excel > Change Excel Axis Location


Reply
 
Thread Tools Display Modes
  #1  
Old 02-05-2010, 09:15 AM
MrDiablo2327 MrDiablo2327 is offline
Newcomer
 
Join Date: Oct 2008
Posts: 3
Default Change Excel Axis Location


Looking for help with graphs in Excel. Have a large data set that I am trying to plot. Because of size, I have formated the x-axis as logarithmic scale. When doing this, the y-axis automatically shifts to the center of the plot. I would like to supress this response, either through code and/or a property setting.
Thanks.
Reply With Quote
  #2  
Old 02-05-2010, 11:05 AM
Peter_Aquino's Avatar
Peter_Aquino Peter_Aquino is offline
Contributor

* Expert *
 
Join Date: Sep 2004
Location: San Diego, CA, USA
Posts: 732
Default

I think what you're looking for is the .CrossesAt property of the Chart.Axes object. This property specifies where one axis will cross another. So you would set the value to '1' for the X Axis.
Reply With Quote
Reply

Tags
excel 2007


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
 
 
-->