Syntax for updating chart label via macro

Fri, 29 Jul 2011 12:38:07 GMT

I'm using a macro to swap out dimensions on a chart via button. However, when the new dimension is inserted, I lose the custom label, which is a variable 'vTimeView'. I'm looking for the VB syntax to update the dimension label for object CH54. Thoughts?

Thanks,

Kevin

Syntax for updating chart label via macro

Fri, 29 Jul 2011 15:05:45 GMT

I think they're calling the attribute Title for dimensions (even though there is a ShowLabel attribute as well).

From the API Guide:

set chart = ActiveDocument.Activesheet.CreateStraightTable

chart.AddDimension "ProductType"

chart.AddExpression "sum(Amount)"

chart.AddExpression "count(Customer)"

set cp = chart.GetProperties

set dims = cp.Dimensions

dims(0).Title.v = "Type of product"

chart.SetProperties cp

Keep in mind the dimensions are an array, so if you have more than one, make sure you refer to the correct one. dims(#).

topic Syntax for updating chart label via macro in QlikView

Syntax for updating chart label via macro

Syntax for updating chart label via macro