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
Solved

MS Excel VBA 2010 Graph ScaleType

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

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 50

Expert Comment

by:Rgonzo1971
ID: 40410683
Could you send a dummy?
0
Easy, flexible multimedia distribution & control

Coming soon!  Ideal for large-scale A/V applications, ATEN's VM3200 Modular Matrix Switch is an all-in-one solution that simplifies video wall integration. Easily customize display layouts to see what you want, how you want it in 4k.

 

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 50

Expert Comment

by:Rgonzo1971
ID: 40410916
Thanks
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

This collection of functions covers all the normal rounding methods of just about any numeric value.
Meetings to discuss business process can waste time, and often do .  The meeting's dialog can get confusing when participants have different professional perspectives and backgrounds.  A jointly-developed process picture helps wade through the confu…
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 …
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

809 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