FactAxis (Object)

Member of:

Subcomponent object

Description:

Represents attributes of the Facts axis of a (Live) Chart object, including the associated Fact axis labels and titles. Setting properties for this object is the equivalent of setting properties for the Fact label and title on the Font dialog box.

Example:

This example shows how to set common fact axis attributes:

BarChart.FactsAxis.NumberFormat = "$#,##0.00"
BarChart.FactsAxis.AutoScale = false
BarChart.FactsAxis.ScaleMax = 1000
BarChart.FactsAxis.ScaleMin= 10
BarChart.FactsAxis.Labels.Font.Color = 16711680
BarChart.FactsAxis.Title.Text = "Amount Sales"

Methods:

None

Properties:

AutoScale as Boolean, NumberFormat as String, ScaleMax as Number, ScaleMin as Number

Objects:

Labels object, Title object