Table 7. Significant Property Settings for the Graph
Property
|
Setting
|
Explanation
|
Data.DataSetCount
|
1
|
Specifies that there is only one bar series.
|
Data.PointLabelStyle
|
GraphNoPointLabels
|
This setting specifies that values do not display at the top of each bar.
|
Expressions.CategoryKey
|
Year([ssClose_Date]) * 12 + Month([ssClose_Date]) -1
|
This expression assigns an integer value to the month in which each opportunity occurred. Opportunities with the same month have their revenue summed to generate one bar.
|
Expressions.Category Label
|
[ssClose_Date_ Formatted]
|
Value from which each x-axis label is generated.
|
Expressions.ValueExp
|
Sum(Val([ssRevenue]))
|
Expression for obtaining the y-axis value to plot for each bar.
|
General.GraphType
|
Graph2dBar
|
Specifies that the graph is a 2d bar chart.
|
Graph-Specific.BarGrouping
|
GraphBarNoGrouping
|
Specifies that there is a single series of bars, not multiple series.
|
Graph-Specific.BarOrientation
|
GraphBarVertical
|
Specifies that the bars in the bar graph are vertical rather than horizontal.
|
X-Axis.XAxisStyle
|
GraphZeroOrigin
|
Specifies that the x-axis starts at the value zero.
|
X-Axis.XLabelFormat
|
mm 'yy
|
Specifies a format mask for the x-axis date values, used to generate x-axis labels.
|
X-Axis.XLabelStyle
|
GraphExpressionLabels
|
Specifies that x-axis labels are present and are derived from the CategoryLabel expression.
|
X-Axis.XTitle
|
Time (By Month)
|
Text to appear beneath the x-axis.
|
X-Axis.XValueSet
|
GraphXValuePerDataSet
|
There is one set of x-axis values that applies to all data series.
|
Y-Axis.YAxisPosition
|
GraphYAxisLeft
|
Specifies that the y-axis is displayed and appears on the left side.
|
Y-Axis.YAxisStyle
|
GraphAutoOrigin
|
Specifies that the y-axis origin is determined automatically from the data.
|
Y-Axis.YLabelFormat
|
#,###
|
Format mask for the values displayed next to y-axis tick marks.
|
Y-Axis.YLabelStyle
|
GraphCustomLabels
|
Displays custom labels based on the information you enter in the YLabelsList property.
|
Y-Axis.YTitle
|
Revenue
|
The title to appear alongside the y-axis.
|
Y-Axis.YMajorGridStyle
|
SingleLine
|
Specifies that horizontal lines appear, rather than a grid.
|
Y-Axis.YMajorTickCount
|
5
|
Specifies how many tick marks are displayed on the y-axis.
|
Y-Axis.YVerticalLabels
|
False
|
Specifies that y-axis labels are horizontal rather than vertical.
|