Search Office
Sign in
Home Products Office 365 Docs Samples Downloads Training How To Support Forums
Office and SharePoint development > Office client development > Office 2010 > Excel 2010 > Excel 2010 Developer Reference > Microsoft Graph Visual Basic Reference > Properties > TickLabelSpacing Property
Office and SharePoint development
Office client development
Office 2010
Excel 2010
Excel 2010 Developer Reference
Microsoft Graph Visual Basic Reference
Properties
Properties
Application Property
ApplyPictToEnd Property
ApplyPictToFront Property
ApplyPictToSides Property
Area3DGroup Property
AutoCorrect Property
AutoScaleFont Property
AutoScaling Property
AutoText Property
AxisBetweenCategories Property
AxisGroup Property
AxisTitle Property
BackColor Property (Graph)
Background Property
Backward Property
Bar3DGroup Property
BarShape Property
BaseUnit Property
BaseUnitIsAuto Property
Bold Property
Border Property
BubbleScale Property
CapitalizeNamesOfDays Property
Caption Property (Graph)
CategoryType Property
CellDragAndDrop Property
Cells Property
ChartArea Property
ChartTitle Property
ChartType Property
Color Property
ColorIndex Property
Colors Property
Column3DGroup Property
Columns Property
ColumnWidth Property
CommandBars Property
Corners Property
CorrectCapsLock Property
CorrectSentenceCap Property
Count Property (Graph)
Creator Property
Crosses Property
CrossesAt Property
DataLabel Property
DataSheet Property
DataTable Property
DepthPercent Property
DisplayAlerts Property
DisplayAutoCorrectOptions Property
DisplayBlanksAs Property
DisplayEquation Property
DisplayRSquared Property
DisplayUnit Property
DisplayUnitCustom Property
DisplayUnitLabel Property
DoughnutHoleSize Property
DownBars Property
DropLines Property
Elevation Property
EndStyle Property
ErrorBars Property
Explosion Property
Fill Property
FirstSliceAngle Property
Floor Property
Font Property
FontStyle Property
ForeColor Property
Forward Property
GapDepth Property
GapWidth Property
GradientColorType Property
GradientDegree Property
GradientStyle Property
GradientVariant Property
Has3DEffect Property
Has3DShading Property
HasAxis Property
HasBorderHorizontal Property
HasBorderOutline Property
HasBorderVertical Property
HasDataLabel Property
HasDataLabels Property
HasDataTable Property
HasDisplayUnitLabel Property
HasDropLines Property
HasErrorBars Property
HasHiLoLines Property
HasLeaderLines Property
HasLegend Property
HasLinks Property
HasMajorGridlines Property
HasMinorGridlines Property
HasRadarAxisLabels Property
HasSeriesLines Property
HasTitle Property
HasUpDownBars Property
Height Property (Graph)
HeightPercent Property
HiLoLines Property
HorizontalAlignment Property (Graph)
Include Property
Index Property
InsideHeight Property
InsideLeft Property
InsideTop Property
InsideWidth Property
Intercept Property
InterceptIsAuto Property
Interior Property
InvertIfNegative Property
Italic Property
Item Property (Graph)
LeaderLines Property
Left Property
Legend Property
LegendKey Property
Line3DGroup Property
LineStyle Property
MajorGridlines Property
MajorTickMark Property
MajorUnit Property
MajorUnitIsAuto Property
MajorUnitScale Property
MarkerBackgroundColor Property
MarkerBackgroundColorIndex Property
MarkerForegroundColor Property
MarkerForegroundColorIndex Property
MarkerSize Property
MarkerStyle Property
MaximumScale Property
MaximumScaleIsAuto Property
MinimumScale Property
MinimumScaleIsAuto Property
MinorGridlines Property
MinorTickMark Property
MinorUnit Property
MinorUnitIsAuto Property
MinorUnitScale Property
MoveAfterReturn Property
Name Property (Graph)
NameIsAuto Property
NumberFormat Property
NumberFormatLocal Property
Offset Property
Order Property
Orientation Property (Graph)
OutlineFont Property
Overlap Property
Parent Property
Pattern Property
PatternColor Property
PatternColorIndex Property
Period Property
Perspective Property
PictureType Property
PictureUnit Property
Pie3DGroup Property
PlotArea Property
PlotBy Property
PlotOnX Property
Position Property
PresetGradientType Property
PresetTexture Property
RadarAxisLabels Property
Range Property
ReadingOrder Property
ReplacementList Property
ReplaceText Property
ReversePlotOrder Property
RGB Property
RightAngleAxes Property
Rotation Property
Rows Property (Graph)
ScaleType Property
SchemeColor Property
SecondaryPlot Property
SecondPlotSize Property
Separator Property
SeriesLines Property
Shadow Property
ShowBubbleSize Property
ShowCategoryName Property
ShowChartTipNames Property
ShowChartTipValues Property
ShowLegendKey Property
ShowNegativeBubbles Property
ShowPercentage Property
ShowSeriesName Property
ShowValue Property
Size Property
SizeRepresents Property
Smooth Property
SplitType Property
SplitValue Property
Strikethrough Property
Subscript Property
Superscript Property
SurfaceGroup Property
Text Property
TextureName Property
TextureType Property
TickLabelPosition Property
TickLabels Property
TickLabelSpacing Property
TickMarkSpacing Property
Top Property
TwoInitialCapitals Property
Type Property
Underline Property
UpBars Property
Value Property (Graph)
VaryByCategories Property
Version Property
VerticalAlignment Property (Graph)
Visible Property (Graph)
Walls Property
WallsAndGridlines2D Property
Weight Property
Width Property (Graph)
WindowState Property
Expand Minimize
This topic has not yet been rated - Rate this topic

TickLabelSpacing Property

Office 2010

Returns or sets the number of categories or series between tick-mark labels. Applies only to category and series axes. Read/write Long.

Tick-mark label spacing on the value axis is always calculated by Microsoft Graph.

This example sets the number of categories between tick-mark labels on the category axis.

Copy 
myChart.Axes(xlCategory).TickLabelSpacing = 10
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.