Solved

MS Excel VBA 2010 Graph ScaleType

Posted on 2014-10-29
8
362 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
 

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
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Open Office very very slow 3 113
Is COM supported from Apache 1 44
MS Project 2013 - notes documentation 8 48
Licensing Sharepoint 2016 for developers 11 26
As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

919 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now