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

Thread Tools Display Modes
Old 02-05-2010, 10:15 AM
MrDiablo2327 MrDiablo2327 is offline
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.
Reply With Quote
Old 02-05-2010, 12:05 PM
Peter_Aquino's Avatar
Peter_Aquino Peter_Aquino is offline

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

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

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


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.
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
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..