Solved

MS Excel VBA 2010 Graph ScaleType

Posted on 2014-10-29
8
373 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
  • 5
  • 3
8 Comments
 
LVL 49

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 49

Expert Comment

by:Rgonzo1971
ID: 40410683
Could you send a dummy?
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

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 49

Expert Comment

by:Rgonzo1971
ID: 40410916
Thanks
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
As freelancing is becoming more and more common in the tech industry, certain obstacles are proving to be a challenge to those who are used to more traditional, structured employment. This article is meant to help identify such obstacles and offer a…
This video walks the viewer through the process of creating an MLA formatted document, as well as a bibliography with citations.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

773 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