Expression label to bold by macro

[Anonymous]

Hi, everybody. How to bold the expression label using macro?

[m_woolf · Accepted solution]

From the API:

set chart = ActiveDocument.ActiveSheet.CreateStraightTable

chart.AddDimension "Customer"

chart.AddDimension "ProductType"

chart.AddExpression "sum(Amount)"

set cp = chart.GetProperties

set expr = cp.Expressions.Item(0).Item(0).Data.ExpressionVisual

expr.Label.v = "Sales"

expr.LabelAdjust = 2

expr.VisualCues.LowLimit.v = 10

expr.VisualCues.LowCue.Color.Col = RGB(255,0,0)       'red

expr.VisualCues.LowCue.FontStyleMod = 2           'bold

expr.VisualCues.LowCue.SizeMod = 1                '+20%

chart.SetProperties cp

[Anonymous]

Yes, that's exactly what I need. Thanks a lot.

But, what API did you read that in?.  I saw no answer there.

[m_woolf]

The API Guide I was referring to is a QV app. I have pasted it for your review.

[Anonymous]

Thanks again. It's really useful app.