Solved

MS Excel VBA 2010 Graph ScaleType

Posted on 2014-10-29
8
396 Views
Last Modified: 2014-10-29
I have a problem upgrading from MS Excel 2003 to 2010. The Scaletype does not exist anymore, and it does not accept xlLinear anymore.


Worksheets("ABCDEF").Activate
ActiveSheet.ChartObjects("Graph1").Activate
    ActiveChart.ChartArea.Select
    ActiveChart.Axes(xlCategory, xlSecondary).Select
    With ActiveChart.Axes(xlCategory, xlSecondary)
        .MinimumScale = 0
        .MaximumScale = 500
        .MinorUnitIsAuto = True
        .MajorUnitIsAuto = True
        .CrossesAt = 0
        .ReversePlotOrder = False
       '.ScaleType = xlLinear
        .DisplayUnit = xlNone
        .TickLabels.NumberFormat = "general"
        .TickLabels.Font.Size = 9
       
    End With
0
Comment
Question by:Frans_Truyens
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
8 Comments
 
LVL 51

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 40410675
Hi,

pls try

ScaleType = xlScaleLinear

Regards
0
 

Author Comment

by:Frans_Truyens
ID: 40410681
I tried already. The constants give the same value. They return the same integer.
0
 
LVL 51

Expert Comment

by:Rgonzo1971
ID: 40410683
Could you send a dummy?
0
Portable, direct connect server access

The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

 

Author Comment

by:Frans_Truyens
ID: 40410686
I tried to send logaritmacally, just to try but it does not work. In Excel 2003 it works fine, but not in 2010
0
 

Author Comment

by:Frans_Truyens
ID: 40410744
The second axis just disappears when you omit this constant. But when you put it there, it doesn't work. It is something that worked fine in MS Excel 2003 but not in 2010. Is there a workaround?
0
 

Author Comment

by:Frans_Truyens
ID: 40410792
We solved the problem. It was something else in the code.
0
 

Author Closing Comment

by:Frans_Truyens
ID: 40410866
Thanks a lot.
0
 
LVL 51

Expert Comment

by:Rgonzo1971
ID: 40410916
Thanks
0

Featured Post

Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SAPE.heur.AE935 Visual Studio 3 74
Post a good COM tutorial 1 72
How to code SharePoint 2013 online 4 97
VB.Net creating Contact in Outlook 1 96
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question