How to set Chart Property

[#1]

Hi All,

I have a chart area and I have two different drill downs which I am controlling through buttons by toggleing and assinging dimensions programatically using VB Script.

My question is that how to set Property of Chart->Presentation->Max Visible Number and Show X-Axis Scrollbar using VB Script.

Sample code would be a great help. Ive tried finding in API Guide but cudnt find.

Thanks and regards

Josh

[#2]

Josh,

Macros that set attributes of an object are always best avoided as they cause instability in the document.

Always better to have multiple charts that are activated/hidden as appropriate.

Regards,

Gordon

[#3]

thanks for your reply Gordon and agreed to some extent but what is the use of Scripting and direct access to objects and their properties in this product then?

[#4]

In the server environment, that is a question I have asked myself to be honest! I have just posted a question about OnPostReload which confuses me some more...

[#5]

This is not a solution, but I believe, an pointer in the right direction. Some objects have methods called get and setProperties. They are not well documented, I believe, but they hold assorted properties like the two you are looking for. Maybe those you want are there too.

ActiveDocument.getsheetobject("mainReport").addDimension("=if($(ReportFilter2),Category,null())")
filterSet = true
set Graph = ActiveDocument.GetSheetObject("mainReport")
set cp = Graph.GetProperties
set dims = cp.Dimensions
dims(dims.Count-1).Title.v = "Category"
dims(dims.Count-1).NullSuppression = true
dims(dims.Count-1).ColWidth = 400
dims(dims.Count-1).SortCriteria.SortByAscii = 1
dims(dims.Count-1).SortCriteria.SortByLoadOrder = 0
Graph.SetProperties cp