ÿþ<html xmlns:mso="urn:schemas-microsoft-com:office:office" xmlns:msdt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"><script> function getHelp(link) { window.open("http://" + location.hostname + "/Explorer/" + link, "_help", "left=400,resizable=yes,toolbar=yes,width=200,height=200,scrollbars=yes").focus(); } function showReturns(returns) { window.status = returns; } </script><head> <!--[if gte mso 9]><xml> <mso:CustomDocumentProperties> <mso:Order msdt:dt="string">348000.000000000</mso:Order> </mso:CustomDocumentProperties> </xml><![endif]--> <title>Chapter 17</title> <!--mstheme--><link rel="stylesheet" type="text/css" id="onetidThemeCSS" href="../_themes/simple/simp1011-1200.css"><meta name="Microsoft Theme" content="simple 1011, default"> </head><body> <H1>Excel Chart Appearance Objects</H1> <h2>ChartColorFormat (1997) <img src="MSGBOX02.ICO" alt="Used only with charts. Represents the color of a one-color object or the foreground or background color of an object with a gradient or patterned fill." width="16" height="16" onclick="getHelp('xlobjChartColorFormat.htm');showMozHelp('Used only with charts. Represents the color of a one-color object or the foreground or background color of an object with a gradient or patterned fill.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>RGB<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example sets the interior color of the range A1:A10 to the chart area foreground fill color on chart one." width="16" height="16" onclick="getHelp('xlproRGB.htm')" onmouseover="showReturns('Returns: Int32')"><br>SchemeColor [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example sets the foreground color, background color, and gradient for the chart area fill on chart one." width="16" height="16" onclick="getHelp('xlproSchemeColor.htm')" onmouseover="showReturns('Returns: Int32')"><br>Type<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the Axis type. Read/write XlAxisType." width="16" height="16" onclick="getHelp('xlproType.htm')" onmouseover="showReturns('Returns: Int32')"><br><h2>ChartFillFormat (1997) <img src="MSGBOX02.ICO" alt="Used only with charts. Represents fill formatting for chart elements." width="16" height="16" onclick="getHelp('xlobjChartFillFormat.htm');showMozHelp('Used only with charts. Represents fill formatting for chart elements.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>BackColor<input type="image" src="MSGBOX02.ICO" alt="Returns: ChartColorFormat. This example sets the foreground color, background color, and gradient for the chart area fill on chart one." width="16" height="16" onclick="getHelp('xlproBackColor.htm')" onmouseover="showReturns('Returns: ChartColorFormat')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>ForeColor<input type="image" src="MSGBOX02.ICO" alt="Returns: ChartColorFormat. This example sets the foreground color, background color, and gradient for the chart area fill on chart one." width="16" height="16" onclick="getHelp('xlproForeColor.htm')" onmouseover="showReturns('Returns: ChartColorFormat')"><br>GradientColorType<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoGradientColorType. This example sets the fill format for chart two to the same style used for chart one." width="16" height="16" onclick="getHelp('xlproGradientColorType.htm')" onmouseover="showReturns('Returns: MsoGradientColorType')"><br>GradientDegree<input type="image" src="MSGBOX02.ICO" alt="Returns: Single. Returns the gradient degree of the specified one-color shaded fill as a floating-point value from 0.0 (dark) through 1.0 (light). Read-only Single." width="16" height="16" onclick="getHelp('xlproGradientDegree.htm')" onmouseover="showReturns('Returns: Single')"><br>GradientStyle<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoGradientStyle. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: MsoGradientStyle')"><br>GradientVariant<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns the shade variant for the specified fill as an integer value from 1 through 4. The values for this property correspond to the gradient variants (numbered from left to right and from top to bottom) on the Gradient tab in the Fill Effects dialog box. Read-only Long." width="16" height="16" onclick="getHelp('xlproGradientVariant.htm')" onmouseover="showReturns('Returns: Int32')"><br>OneColorGradient(Style, Variant, Degree) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. This example sets the fill format for chart two to the same style used for chart one." width="16" height="16" onclick="getHelp('xlmthOneColorGradient.htm')" onmouseover="showReturns('Returns: Void')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Pattern<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoPatternType. This example adds a crisscross pattern to the interior of cell A1 on Sheet1." width="16" height="16" onclick="getHelp('xlproPattern.htm')" onmouseover="showReturns('Returns: MsoPatternType')"><br>Patterned(Pattern) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. This example sets the fill pattern for chart one." width="16" height="16" onclick="getHelp('xlmthPatterned.htm')" onmouseover="showReturns('Returns: Void')"><br>PresetGradient(Style, Variant, PresetGradientType) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Sets the specified fill to a preset gradient." width="16" height="16" onclick="getHelp('xlmthPresetGradient.htm')" onmouseover="showReturns('Returns: Void')"><br>PresetGradientType<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoPresetGradientType. Use the PresetGradient method to set the preset gradient type for the fill." width="16" height="16" onclick="getHelp('xlproPresetGradientType.htm')" onmouseover="showReturns('Returns: MsoPresetGradientType')"><br>PresetTexture<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoPresetTexture. Use the PresetTextured method to set the preset texture for the fill." width="16" height="16" onclick="getHelp('xlproPresetTexture.htm')" onmouseover="showReturns('Returns: MsoPresetTexture')"><br>PresetTextured(PresetTexture) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Sets the specified fill format to a preset texture." width="16" height="16" onclick="getHelp('xlmthPresetTextured.htm')" onmouseover="showReturns('Returns: Void')"><br>Solid() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Sets the specified fill to a uniform color. Use this method to convert a gradient, textured, patterned, or background fill back to a solid fill." width="16" height="16" onclick="getHelp('xlmthSolid.htm')" onmouseover="showReturns('Returns: Void')"><br>TextureName<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns the name of the custom texture file for the specified fill. Read-only String." width="16" height="16" onclick="getHelp('xlproTextureName.htm')" onmouseover="showReturns('Returns: String')"><br>TextureType<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTextureType. Use the UserTextured method to set the texture type for the fill." width="16" height="16" onclick="getHelp('xlproTextureType.htm')" onmouseover="showReturns('Returns: MsoTextureType')"><br>TwoColorGradient(Style, Variant) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Sets the specified fill to a two-color gradient." width="16" height="16" onclick="getHelp('xlmthTwoColorGradient.htm')" onmouseover="showReturns('Returns: Void')"><br>Type<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoFillType. Returns or sets the Axis type. Read/write XlAxisType." width="16" height="16" onclick="getHelp('xlproType.htm')" onmouseover="showReturns('Returns: MsoFillType')"><br>UserPicture([PictureFile], [PictureFormat], [PictureStackUnit], [PicturePlacement]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Fills the specified shape with an image." width="16" height="16" onclick="getHelp('xlmthUserPicture.htm')" onmouseover="showReturns('Returns: Void')"><br>UserTextured(TextureFile) <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Fills the specified shape with small tiles of an image. If you want to fill the shape with one large image, use the UserPicture method." width="16" height="16" onclick="getHelp('xlmthUserTextured.htm')" onmouseover="showReturns('Returns: Void')"><br>Visible [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: MsoTriState. Visible property as it applies to the ChartFillFormat, FillFormat, LineFormat, ShadowFormat, Shape, ShapeRange, and ThreeDFormat objects." width="16" height="16" onclick="getHelp('xlproVisible.htm')" onmouseover="showReturns('Returns: MsoTriState')"><br><h2>Corners (1995) <img src="MSGBOX02.ICO" alt="Represents the corners of a 3-D chart. This object isnt a collection." width="16" height="16" onclick="getHelp('xlobjCorners.htm');showMozHelp('Represents the corners of a 3-D chart. This object isnt a collection.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Name<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Name property and related properties given an OLAP data source with the unique name [Europe].[France].[Paris] and a non-OLAP data source with the item name Paris." width="16" height="16" onclick="getHelp('xlproName.htm')" onmouseover="showReturns('Returns: String')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Select() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Selects the object." width="16" height="16" onclick="getHelp('xlmthSelect.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>DataLabel (1995) <img src="MSGBOX02.ICO" alt="Represents the data label on a chart point or trendline. On a series, the DataLabel object is a member of the DataLabels collection. The DataLabels collection contains a DataLabel object for each point. For a series without definable points (such as an area series), the DataLabels collection contains a single DataLabel object." width="16" height="16" onclick="getHelp('xlobjDataLabel.htm');showMozHelp('Represents the data label on a chart point or trendline. On a series, the DataLabel object is a member of the DataLabels collection. The DataLabels collection contains a DataLabel object for each point. For a series without definable points (such as an area series), the DataLabels collection contains a single DataLabel object.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>AutoScaleFont [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. True if the text in the object changes font size when the object size changes. The default value is True. Read/write Variant." width="16" height="16" onclick="getHelp('xlproAutoScaleFont.htm')" onmouseover="showReturns('Returns: Object')"><br>AutoText [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the object automatically generates appropriate text based on context. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproAutoText.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Border<input type="image" src="MSGBOX02.ICO" alt="Returns: Border. This example sets the color of the chart area border of Chart1 to red." width="16" height="16" onclick="getHelp('xlproBorder.htm')" onmouseover="showReturns('Returns: Border')"><br>Caption [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Caption property and related properties, given an OLAP data source with the unique name [Europe].[France].[Paris] and a non-OLAP data source with the item name Paris." width="16" height="16" onclick="getHelp('xlproCaption.htm')" onmouseover="showReturns('Returns: String')"><br>Characters<input type="image" src="MSGBOX02.ICO" alt="Returns: Characters. Returns a Characters object that represents a range of characters within the object text. You can use the Characters object to format characters within a text string." width="16" height="16" onclick="getHelp('xlproCharacters.htm')" onmouseover="showReturns('Returns: Characters')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Object')"><br>Fill<input type="image" src="MSGBOX02.ICO" alt="Returns: ChartFillFormat. Returns a FillFormat object that contains fill formatting properties for the specified chart or shape. Read-only." width="16" height="16" onclick="getHelp('xlproFill.htm')" onmouseover="showReturns('Returns: ChartFillFormat')"><br>Font<input type="image" src="MSGBOX02.ICO" alt="Returns: Font. Font property as it applies to the CellFormat object." width="16" height="16" onclick="getHelp('xlproFont.htm')" onmouseover="showReturns('Returns: Font')"><br>HorizontalAlignment [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Some of these constants may not be available to you, depending on the language support (U.S. English, for example) that you've selected or installed." width="16" height="16" onclick="getHelp('xlproHorizontalAlignment.htm')" onmouseover="showReturns('Returns: Object')"><br>Interior<input type="image" src="MSGBOX02.ICO" alt="Returns: Interior. Interior property as it applies to the CellFormat object." width="16" height="16" onclick="getHelp('xlproInterior.htm')" onmouseover="showReturns('Returns: Interior')"><br>Left [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. If the window is maximized, Application.Left returns a negative number that varies based on the width of the window border. Setting Application.Left to 0 (zero) will make the window a tiny bit smaller than it would be if the application window were maximized. In other words, if Application.Left is 0 (zero), the left border of the main Microsoft Excel window will just barely be visible on the screen. " width="16" height="16" onclick="getHelp('xlproLeft.htm')" onmouseover="showReturns('Returns: Double')"><br>Name<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Name property and related properties given an OLAP data source with the unique name [Europe].[France].[Paris] and a non-OLAP data source with the item name Paris." width="16" height="16" onclick="getHelp('xlproName.htm')" onmouseover="showReturns('Returns: String')"><br>NumberFormat [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. NumberFormat property as it applies to the DataLabel, DataLabels, PivotField, Style, and TickLabels objects." width="16" height="16" onclick="getHelp('xlproNumberFormat.htm')" onmouseover="showReturns('Returns: String')"><br>NumberFormatLinked [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the number format is linked to the cells (so that the number format changes in the labels when it changes in the cells). Read/write Boolean." width="16" height="16" onclick="getHelp('xlproNumberFormatLinked.htm')" onmouseover="showReturns('Returns: Boolean')"><br>NumberFormatLocal [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. NumberFormatLocal property as it applies to the Style object." width="16" height="16" onclick="getHelp('xlproNumberFormatLocal.htm')" onmouseover="showReturns('Returns: Object')"><br>Orientation [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. For OLAP data sources, setting this property for one field in a hierarchy sets the orientation for the other fields in the same hierarchy. Dimension fields can only be oriented in the row, column, and page field areas of the PivotTable report. Measure fields can only be oriented in the data area. Setting a hierarchy or data field to xlHidden removes the hierarchy or field from the PivotTable report." width="16" height="16" onclick="getHelp('xlproOrientation.htm')" onmouseover="showReturns('Returns: Object')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Position [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlDataLabelPosition. This example moves the chart legend to the bottom of the chart." width="16" height="16" onclick="getHelp('xlproPosition.htm')" onmouseover="showReturns('Returns: XlDataLabelPosition')"><br>ReadingOrder [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the reading order for the specified object. Can be one of the following constants: xlRTL (right-to-left), xlLTR (left-to-right), or xlContext. Read/write Long." width="16" height="16" onclick="getHelp('xlproReadingOrder.htm')" onmouseover="showReturns('Returns: Int32')"><br>Select() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Selects the object." width="16" height="16" onclick="getHelp('xlmthSelect.htm')" onmouseover="showReturns('Returns: Object')"><br>Separator [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Sets or returns a Variant representing the separator used for the data labels on a chart. Read/write." width="16" height="16" onclick="getHelp('xlproSeparator.htm')" onmouseover="showReturns('Returns: Object')"><br>Shadow [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the font is a shadow font or if the object has a shadow. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproShadow.htm')" onmouseover="showReturns('Returns: Boolean')"><br>ShowBubbleSize [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True to show the bubble size for the data labels on a chart. False to hide. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproShowBubbleSize.htm')" onmouseover="showReturns('Returns: Boolean')"><br>ShowCategoryName [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True to display the category name for the data labels on a chart. False to hide. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproShowCategoryName.htm')" onmouseover="showReturns('Returns: Boolean')"><br>ShowLegendKey [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the data label legend key is visible. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproShowLegendKey.htm')" onmouseover="showReturns('Returns: Boolean')"><br>ShowPercentage [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True to display the percentage value for the data labels on a chart. False to hide. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproShowPercentage.htm')" onmouseover="showReturns('Returns: Boolean')"><br>ShowSeriesName [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Returns or sets a Boolean to indicate the series name display behavior for the data labels on a chart. True to show the series name. False to hide. Read/write." width="16" height="16" onclick="getHelp('xlproShowSeriesName.htm')" onmouseover="showReturns('Returns: Boolean')"><br>ShowValue [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Returns or sets a Boolean corresponding to a specified chart's data label values display behavior. True displays the values. False to hide. Read/write." width="16" height="16" onclick="getHelp('xlproShowValue.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Text [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. Returns or sets the text for the specified object. Read-only String for the Range object, read/write String for all other objects." width="16" height="16" onclick="getHelp('xlproText.htm')" onmouseover="showReturns('Returns: String')"><br>Top [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. The distance from the top edge of the screen to the top edge of the main Microsoft Excel window. If the application window is minimized, this property controls the position of the window icon (anywhere on the screen). Read/write Double." width="16" height="16" onclick="getHelp('xlproTop.htm')" onmouseover="showReturns('Returns: Double')"><br>Type [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns or sets the Axis type. Read/write XlAxisType." width="16" height="16" onclick="getHelp('xlproType.htm')" onmouseover="showReturns('Returns: Object')"><br>VerticalAlignment [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Some of these constants may not be available to you, depending on the language support (U.S. English, for example) that you've selected or installed." width="16" height="16" onclick="getHelp('xlproVerticalAlignment.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>DataLabels (1995) <img src="MSGBOX02.ICO" alt="A collection of all the DataLabel objects for the specified series. Each DataLabel object represents a data label for a point or trendline. For a series without definable points (such as an area series), the DataLabels collection contains a single data label." width="16" height="16" onclick="getHelp('xlobjDataLabels.htm');showMozHelp('A collection of all the DataLabel objects for the specified series. Each DataLabel object represents a data label for a point or trendline. For a series without definable points (such as an area series), the DataLabels collection contains a single data label.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>AutoScaleFont [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. True if the text in the object changes font size when the object size changes. The default value is True. Read/write Variant." width="16" height="16" onclick="getHelp('xlproAutoScaleFont.htm')" onmouseover="showReturns('Returns: Object')"><br>AutoText [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the object automatically generates appropriate text based on context. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproAutoText.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Border<input type="image" src="MSGBOX02.ICO" alt="Returns: Border. This example sets the color of the chart area border of Chart1 to red." width="16" height="16" onclick="getHelp('xlproBorder.htm')" onmouseover="showReturns('Returns: Border')"><br>Count<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example displays the number of columns in the selection on Sheet1. The code also tests for a multiple-area selection; if one exists, the code loops on the areas of the multiple-area selection." width="16" height="16" onclick="getHelp('xlproCount.htm')" onmouseover="showReturns('Returns: Int32')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Object')"><br>Fill<input type="image" src="MSGBOX02.ICO" alt="Returns: ChartFillFormat. Returns a FillFormat object that contains fill formatting properties for the specified chart or shape. Read-only." width="16" height="16" onclick="getHelp('xlproFill.htm')" onmouseover="showReturns('Returns: ChartFillFormat')"><br>Font<input type="image" src="MSGBOX02.ICO" alt="Returns: Font. Font property as it applies to the CellFormat object." width="16" height="16" onclick="getHelp('xlproFont.htm')" onmouseover="showReturns('Returns: Font')"><br>GetEnumerator() <input type="image" src="MSGBOX02.ICO" alt="Returns: IEnumerator. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: IEnumerator')"><br>HorizontalAlignment [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Some of these constants may not be available to you, depending on the language support (U.S. English, for example) that you've selected or installed." width="16" height="16" onclick="getHelp('xlproHorizontalAlignment.htm')" onmouseover="showReturns('Returns: Object')"><br>Interior<input type="image" src="MSGBOX02.ICO" alt="Returns: Interior. Interior property as it applies to the CellFormat object." width="16" height="16" onclick="getHelp('xlproInterior.htm')" onmouseover="showReturns('Returns: Interior')"><br>Item(Index) <input type="image" src="MSGBOX02.ICO" alt="Returns: DataLabel. The text name of the object is the value of the Caption property." width="16" height="16" onclick="getHelp('xlmthItem.htm')" onmouseover="showReturns('Returns: DataLabel')"><br>Name<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Name property and related properties given an OLAP data source with the unique name [Europe].[France].[Paris] and a non-OLAP data source with the item name Paris." width="16" height="16" onclick="getHelp('xlproName.htm')" onmouseover="showReturns('Returns: String')"><br>NumberFormat [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. NumberFormat property as it applies to the DataLabel, DataLabels, PivotField, Style, and TickLabels objects." width="16" height="16" onclick="getHelp('xlproNumberFormat.htm')" onmouseover="showReturns('Returns: String')"><br>NumberFormatLinked [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the number format is linked to the cells (so that the number format changes in the labels when it changes in the cells). Read/write Boolean." width="16" height="16" onclick="getHelp('xlproNumberFormatLinked.htm')" onmouseover="showReturns('Returns: Boolean')"><br>NumberFormatLocal [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. NumberFormatLocal property as it applies to the Style object." width="16" height="16" onclick="getHelp('xlproNumberFormatLocal.htm')" onmouseover="showReturns('Returns: Object')"><br>Orientation [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. For OLAP data sources, setting this property for one field in a hierarchy sets the orientation for the other fields in the same hierarchy. Dimension fields can only be oriented in the row, column, and page field areas of the PivotTable report. Measure fields can only be oriented in the data area. Setting a hierarchy or data field to xlHidden removes the hierarchy or field from the PivotTable report." width="16" height="16" onclick="getHelp('xlproOrientation.htm')" onmouseover="showReturns('Returns: Object')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Position [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlDataLabelPosition. This example moves the chart legend to the bottom of the chart." width="16" height="16" onclick="getHelp('xlproPosition.htm')" onmouseover="showReturns('Returns: XlDataLabelPosition')"><br>ReadingOrder [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the reading order for the specified object. Can be one of the following constants: xlRTL (right-to-left), xlLTR (left-to-right), or xlContext. Read/write Long." width="16" height="16" onclick="getHelp('xlproReadingOrder.htm')" onmouseover="showReturns('Returns: Int32')"><br>Select() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Selects the object." width="16" height="16" onclick="getHelp('xlmthSelect.htm')" onmouseover="showReturns('Returns: Object')"><br>Separator [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Sets or returns a Variant representing the separator used for the data labels on a chart. Read/write." width="16" height="16" onclick="getHelp('xlproSeparator.htm')" onmouseover="showReturns('Returns: Object')"><br>Shadow [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the font is a shadow font or if the object has a shadow. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproShadow.htm')" onmouseover="showReturns('Returns: Boolean')"><br>ShowBubbleSize [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True to show the bubble size for the data labels on a chart. False to hide. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproShowBubbleSize.htm')" onmouseover="showReturns('Returns: Boolean')"><br>ShowCategoryName [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True to display the category name for the data labels on a chart. False to hide. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproShowCategoryName.htm')" onmouseover="showReturns('Returns: Boolean')"><br>ShowLegendKey [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the data label legend key is visible. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproShowLegendKey.htm')" onmouseover="showReturns('Returns: Boolean')"><br>ShowPercentage [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True to display the percentage value for the data labels on a chart. False to hide. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproShowPercentage.htm')" onmouseover="showReturns('Returns: Boolean')"><br>ShowSeriesName [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Returns or sets a Boolean to indicate the series name display behavior for the data labels on a chart. True to show the series name. False to hide. Read/write." width="16" height="16" onclick="getHelp('xlproShowSeriesName.htm')" onmouseover="showReturns('Returns: Boolean')"><br>ShowValue [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. Returns or sets a Boolean corresponding to a specified chart's data label values display behavior. True displays the values. False to hide. Read/write." width="16" height="16" onclick="getHelp('xlproShowValue.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Type [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns or sets the Axis type. Read/write XlAxisType." width="16" height="16" onclick="getHelp('xlproType.htm')" onmouseover="showReturns('Returns: Object')"><br>VerticalAlignment [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Some of these constants may not be available to you, depending on the language support (U.S. English, for example) that you've selected or installed." width="16" height="16" onclick="getHelp('xlproVerticalAlignment.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>DownBars (1995) <img src="MSGBOX02.ICO" alt="Represents the down bars in a chart group. Down bars connect points on the first series in the chart group with lower values on the last series (the lines go down from the first series). Only 2-D line groups that contain at least two series can have down bars. This object isnt a collection. Theres no object that represents a single down bar; you either have up bars and down bars turned on for all points in a chart group or you have them turned off." width="16" height="16" onclick="getHelp('xlobjDownBars.htm');showMozHelp('Represents the down bars in a chart group. Down bars connect points on the first series in the chart group with lower values on the last series (the lines go down from the first series). Only 2-D line groups that contain at least two series can have down bars. This object isnt a collection. Theres no object that represents a single down bar; you either have up bars and down bars turned on for all points in a chart group or you have them turned off.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Border<input type="image" src="MSGBOX02.ICO" alt="Returns: Border. This example sets the color of the chart area border of Chart1 to red." width="16" height="16" onclick="getHelp('xlproBorder.htm')" onmouseover="showReturns('Returns: Border')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Object')"><br>Fill<input type="image" src="MSGBOX02.ICO" alt="Returns: ChartFillFormat. Returns a FillFormat object that contains fill formatting properties for the specified chart or shape. Read-only." width="16" height="16" onclick="getHelp('xlproFill.htm')" onmouseover="showReturns('Returns: ChartFillFormat')"><br>Interior<input type="image" src="MSGBOX02.ICO" alt="Returns: Interior. Interior property as it applies to the CellFormat object." width="16" height="16" onclick="getHelp('xlproInterior.htm')" onmouseover="showReturns('Returns: Interior')"><br>Name<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Name property and related properties given an OLAP data source with the unique name [Europe].[France].[Paris] and a non-OLAP data source with the item name Paris." width="16" height="16" onclick="getHelp('xlproName.htm')" onmouseover="showReturns('Returns: String')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Select() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Selects the object." width="16" height="16" onclick="getHelp('xlmthSelect.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>DropLines (1995) <img src="MSGBOX02.ICO" alt="Represents the drop lines in a chart group. Drop lines connect the points in the chart with the x-axis. Only line and area chart groups can have drop lines. This object isnt a collection. Theres no object that represents a single drop line; you either have drop lines turned on for all points in a chart group or you have them turned off." width="16" height="16" onclick="getHelp('xlobjDropLines.htm');showMozHelp('Represents the drop lines in a chart group. Drop lines connect the points in the chart with the x-axis. Only line and area chart groups can have drop lines. This object isnt a collection. Theres no object that represents a single drop line; you either have drop lines turned on for all points in a chart group or you have them turned off.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Border<input type="image" src="MSGBOX02.ICO" alt="Returns: Border. This example sets the color of the chart area border of Chart1 to red." width="16" height="16" onclick="getHelp('xlproBorder.htm')" onmouseover="showReturns('Returns: Border')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Object')"><br>Name<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Name property and related properties given an OLAP data source with the unique name [Europe].[France].[Paris] and a non-OLAP data source with the item name Paris." width="16" height="16" onclick="getHelp('xlproName.htm')" onmouseover="showReturns('Returns: String')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Select() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Selects the object." width="16" height="16" onclick="getHelp('xlmthSelect.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>ErrorBars (1995) <img src="MSGBOX02.ICO" alt="Represents the error bars on a chart series. Error bars indicate the degree of uncertainty for chart data. Only series in area, bar, column, line, and scatter groups on a 2-D chart can have error bars. Only series in scatter groups can have x and y error bars. This object isnt a collection. Theres no object that represents a single error bar; you either have x error bars or y error bars turned on for all points in a series or you have them turned off." width="16" height="16" onclick="getHelp('xlobjErrorBars.htm');showMozHelp('Represents the error bars on a chart series. Error bars indicate the degree of uncertainty for chart data. Only series in area, bar, column, line, and scatter groups on a 2-D chart can have error bars. Only series in scatter groups can have x and y error bars. This object isnt a collection. Theres no object that represents a single error bar; you either have x error bars or y error bars turned on for all points in a series or you have them turned off.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Border<input type="image" src="MSGBOX02.ICO" alt="Returns: Border. This example sets the color of the chart area border of Chart1 to red." width="16" height="16" onclick="getHelp('xlproBorder.htm')" onmouseover="showReturns('Returns: Border')"><br>ClearFormats() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Clears the formatting of the object." width="16" height="16" onclick="getHelp('xlmthClearFormats.htm')" onmouseover="showReturns('Returns: Object')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Object')"><br>EndStyle [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlEndStyleCap. Returns or sets the end style for the error bars. Can be one of the following XlEndStyleCap constants: xlCap or xlNoCap. Read/write Long." width="16" height="16" onclick="getHelp('xlproEndStyle.htm')" onmouseover="showReturns('Returns: XlEndStyleCap')"><br>Name<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Name property and related properties given an OLAP data source with the unique name [Europe].[France].[Paris] and a non-OLAP data source with the item name Paris." width="16" height="16" onclick="getHelp('xlproName.htm')" onmouseover="showReturns('Returns: String')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Select() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Selects the object." width="16" height="16" onclick="getHelp('xlmthSelect.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>Floor (2000) <img src="MSGBOX02.ICO" alt="Represents the floor of a 3-D chart" width="16" height="16" onclick="getHelp('xlobjFloor.htm');showMozHelp('Represents the floor of a 3-D chart');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Border<input type="image" src="MSGBOX02.ICO" alt="Returns: Border. This example sets the color of the chart area border of Chart1 to red." width="16" height="16" onclick="getHelp('xlproBorder.htm')" onmouseover="showReturns('Returns: Border')"><br>ClearFormats() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Clears the formatting of the object." width="16" height="16" onclick="getHelp('xlmthClearFormats.htm')" onmouseover="showReturns('Returns: Object')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Fill<input type="image" src="MSGBOX02.ICO" alt="Returns: ChartFillFormat. Returns a FillFormat object that contains fill formatting properties for the specified chart or shape. Read-only." width="16" height="16" onclick="getHelp('xlproFill.htm')" onmouseover="showReturns('Returns: ChartFillFormat')"><br>Interior<input type="image" src="MSGBOX02.ICO" alt="Returns: Interior. Interior property as it applies to the CellFormat object." width="16" height="16" onclick="getHelp('xlproInterior.htm')" onmouseover="showReturns('Returns: Interior')"><br>Name<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Name property and related properties given an OLAP data source with the unique name [Europe].[France].[Paris] and a non-OLAP data source with the item name Paris." width="16" height="16" onclick="getHelp('xlproName.htm')" onmouseover="showReturns('Returns: String')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Paste() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Pastes chart data from the Clipboard into the specified chart." width="16" height="16" onclick="getHelp('xlmthPaste.htm')" onmouseover="showReturns('Returns: Void')"><br>PictureType [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. This example sets series one in Chart1 to stretch pictures. The example should be run on a 2-D column chart with picture data markers." width="16" height="16" onclick="getHelp('xlproPictureType.htm')" onmouseover="showReturns('Returns: Object')"><br>Select() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Selects the object." width="16" height="16" onclick="getHelp('xlmthSelect.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>Gridlines (1995) <img src="MSGBOX02.ICO" alt="Represents major or minor gridlines on a chart axis. Gridlines extend the tick marks on a chart axis to make it easier to see the values associated with the data markers. This object isnt a collection. Theres no object that represents a single gridline; you either have all gridlines for an axis turned on or all of them turned off." width="16" height="16" onclick="getHelp('xlobjGridlines.htm');showMozHelp('Represents major or minor gridlines on a chart axis. Gridlines extend the tick marks on a chart axis to make it easier to see the values associated with the data markers. This object isnt a collection. Theres no object that represents a single gridline; you either have all gridlines for an axis turned on or all of them turned off.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Border<input type="image" src="MSGBOX02.ICO" alt="Returns: Border. This example sets the color of the chart area border of Chart1 to red." width="16" height="16" onclick="getHelp('xlproBorder.htm')" onmouseover="showReturns('Returns: Border')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Object')"><br>Name<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Name property and related properties given an OLAP data source with the unique name [Europe].[France].[Paris] and a non-OLAP data source with the item name Paris." width="16" height="16" onclick="getHelp('xlproName.htm')" onmouseover="showReturns('Returns: String')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Select() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Selects the object." width="16" height="16" onclick="getHelp('xlmthSelect.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>HiLoLines (1995) <img src="MSGBOX02.ICO" alt="Represents the high-low lines in a chart group. High-low lines connect the highest point with the lowest point in every category in the chart group. Only 2-D line groups can have high-low lines. This object isnt a collection. Theres no object that represents a single high-low line; you either have high-low lines turned on for all points in a chart group or you have them turned off." width="16" height="16" onclick="getHelp('xlobjHiLoLines.htm');showMozHelp('Represents the high-low lines in a chart group. High-low lines connect the highest point with the lowest point in every category in the chart group. Only 2-D line groups can have high-low lines. This object isnt a collection. Theres no object that represents a single high-low line; you either have high-low lines turned on for all points in a chart group or you have them turned off.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Border<input type="image" src="MSGBOX02.ICO" alt="Returns: Border. This example sets the color of the chart area border of Chart1 to red." width="16" height="16" onclick="getHelp('xlproBorder.htm')" onmouseover="showReturns('Returns: Border')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Object')"><br>Name<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Name property and related properties given an OLAP data source with the unique name [Europe].[France].[Paris] and a non-OLAP data source with the item name Paris." width="16" height="16" onclick="getHelp('xlproName.htm')" onmouseover="showReturns('Returns: String')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Select() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Selects the object." width="16" height="16" onclick="getHelp('xlmthSelect.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>LeaderLines (1997) <img src="MSGBOX02.ICO" alt="Represents leader lines on a chart. Leader lines connect data labels to data points. This object isnt a collection; theres no object that represents a single leader line." width="16" height="16" onclick="getHelp('xlobjLeaderLines.htm');showMozHelp('Represents leader lines on a chart. Leader lines connect data labels to data points. This object isnt a collection; theres no object that represents a single leader line.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Border<input type="image" src="MSGBOX02.ICO" alt="Returns: Border. This example sets the color of the chart area border of Chart1 to red." width="16" height="16" onclick="getHelp('xlproBorder.htm')" onmouseover="showReturns('Returns: Border')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Void')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Select() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Selects the object." width="16" height="16" onclick="getHelp('xlmthSelect.htm')" onmouseover="showReturns('Returns: Void')"><br><h2>Legend (1995) <img src="MSGBOX02.ICO" alt="Represents the legend in a chart. Each chart can have only one legend. The Legend object contains one or more LegendKey object." width="16" height="16" onclick="getHelp('xlobjLegend.htm');showMozHelp('Represents the legend in a chart. Each chart can have only one legend. The Legend object contains one or more LegendKey object.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>AutoScaleFont [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. True if the text in the object changes font size when the object size changes. The default value is True. Read/write Variant." width="16" height="16" onclick="getHelp('xlproAutoScaleFont.htm')" onmouseover="showReturns('Returns: Object')"><br>Border<input type="image" src="MSGBOX02.ICO" alt="Returns: Border. This example sets the color of the chart area border of Chart1 to red." width="16" height="16" onclick="getHelp('xlproBorder.htm')" onmouseover="showReturns('Returns: Border')"><br>Clear() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. This example clears the formulas and formatting in cells A1:G37 on Sheet1." width="16" height="16" onclick="getHelp('xlmthClear.htm')" onmouseover="showReturns('Returns: Object')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Object')"><br>Fill<input type="image" src="MSGBOX02.ICO" alt="Returns: ChartFillFormat. Returns a FillFormat object that contains fill formatting properties for the specified chart or shape. Read-only." width="16" height="16" onclick="getHelp('xlproFill.htm')" onmouseover="showReturns('Returns: ChartFillFormat')"><br>Font<input type="image" src="MSGBOX02.ICO" alt="Returns: Font. Font property as it applies to the CellFormat object." width="16" height="16" onclick="getHelp('xlproFont.htm')" onmouseover="showReturns('Returns: Font')"><br>Height [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. This example sets the height of the embedded chart." width="16" height="16" onclick="getHelp('xlproHeight.htm')" onmouseover="showReturns('Returns: Double')"><br>Interior<input type="image" src="MSGBOX02.ICO" alt="Returns: Interior. Interior property as it applies to the CellFormat object." width="16" height="16" onclick="getHelp('xlproInterior.htm')" onmouseover="showReturns('Returns: Interior')"><br>Left [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. If the window is maximized, Application.Left returns a negative number that varies based on the width of the window border. Setting Application.Left to 0 (zero) will make the window a tiny bit smaller than it would be if the application window were maximized. In other words, if Application.Left is 0 (zero), the left border of the main Microsoft Excel window will just barely be visible on the screen. " width="16" height="16" onclick="getHelp('xlproLeft.htm')" onmouseover="showReturns('Returns: Double')"><br>LegendEntries([Index]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns an object that represents either a single legend entry (a LegendEntry object) or a collection of legend entries (a LegendEntries object) for the legend." width="16" height="16" onclick="getHelp('xlmthLegendEntries.htm')" onmouseover="showReturns('Returns: Object')"><br>Name<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Name property and related properties given an OLAP data source with the unique name [Europe].[France].[Paris] and a non-OLAP data source with the item name Paris." width="16" height="16" onclick="getHelp('xlproName.htm')" onmouseover="showReturns('Returns: String')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Position [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlLegendPosition. This example moves the chart legend to the bottom of the chart." width="16" height="16" onclick="getHelp('xlproPosition.htm')" onmouseover="showReturns('Returns: XlLegendPosition')"><br>Select() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Selects the object." width="16" height="16" onclick="getHelp('xlmthSelect.htm')" onmouseover="showReturns('Returns: Object')"><br>Shadow [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the font is a shadow font or if the object has a shadow. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproShadow.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Top [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. The distance from the top edge of the screen to the top edge of the main Microsoft Excel window. If the application window is minimized, this property controls the position of the window icon (anywhere on the screen). Read/write Double." width="16" height="16" onclick="getHelp('xlproTop.htm')" onmouseover="showReturns('Returns: Double')"><br>Width [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. This example expands the active window to the maximum size available (assuming that the window isnt maximized)." width="16" height="16" onclick="getHelp('xlproWidth.htm')" onmouseover="showReturns('Returns: Double')"><br><h2>LegendEntries (1995) <img src="MSGBOX02.ICO" alt="A collection of all the LegendKey object." width="16" height="16" onclick="getHelp('xlobjLegendEntries.htm');showMozHelp('A collection of all the LegendKey object.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Count<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example displays the number of columns in the selection on Sheet1. The code also tests for a multiple-area selection; if one exists, the code loops on the areas of the multiple-area selection." width="16" height="16" onclick="getHelp('xlproCount.htm')" onmouseover="showReturns('Returns: Int32')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>GetEnumerator() <input type="image" src="MSGBOX02.ICO" alt="Returns: IEnumerator. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: IEnumerator')"><br>Item(Index) <input type="image" src="MSGBOX02.ICO" alt="Returns: LegendEntry. The text name of the object is the value of the Caption property." width="16" height="16" onclick="getHelp('xlmthItem.htm')" onmouseover="showReturns('Returns: LegendEntry')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>LegendEntry (1995) <img src="MSGBOX02.ICO" alt="Represents a legend entry in a chart legend. The LegendEntry object is a member of the LegendEntries collection. The LegendEntries collection contains all the LegendEntry objects in the legend." width="16" height="16" onclick="getHelp('xlobjLegendEntry.htm');showMozHelp('Represents a legend entry in a chart legend. The LegendEntry object is a member of the LegendEntries collection. The LegendEntries collection contains all the LegendEntry objects in the legend.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>AutoScaleFont [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. True if the text in the object changes font size when the object size changes. The default value is True. Read/write Variant." width="16" height="16" onclick="getHelp('xlproAutoScaleFont.htm')" onmouseover="showReturns('Returns: Object')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Object')"><br>Font<input type="image" src="MSGBOX02.ICO" alt="Returns: Font. Font property as it applies to the CellFormat object." width="16" height="16" onclick="getHelp('xlproFont.htm')" onmouseover="showReturns('Returns: Font')"><br>Height<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. This example sets the height of the embedded chart." width="16" height="16" onclick="getHelp('xlproHeight.htm')" onmouseover="showReturns('Returns: Double')"><br>Index<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. For information about using the Index worksheet function in Visual Basic, see Using Worksheet Functions in Visual Basic." width="16" height="16" onclick="getHelp('xlproIndex.htm')" onmouseover="showReturns('Returns: Int32')"><br>Left<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. If the window is maximized, Application.Left returns a negative number that varies based on the width of the window border. Setting Application.Left to 0 (zero) will make the window a tiny bit smaller than it would be if the application window were maximized. In other words, if Application.Left is 0 (zero), the left border of the main Microsoft Excel window will just barely be visible on the screen. " width="16" height="16" onclick="getHelp('xlproLeft.htm')" onmouseover="showReturns('Returns: Double')"><br>LegendKey<input type="image" src="MSGBOX02.ICO" alt="Returns: LegendKey. Returns a LegendKey object that represents the legend key associated with the entry." width="16" height="16" onclick="getHelp('xlproLegendKey.htm')" onmouseover="showReturns('Returns: LegendKey')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Select() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Selects the object." width="16" height="16" onclick="getHelp('xlmthSelect.htm')" onmouseover="showReturns('Returns: Object')"><br>Top<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. The distance from the top edge of the screen to the top edge of the main Microsoft Excel window. If the application window is minimized, this property controls the position of the window icon (anywhere on the screen). Read/write Double." width="16" height="16" onclick="getHelp('xlproTop.htm')" onmouseover="showReturns('Returns: Double')"><br>Width<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. This example expands the active window to the maximum size available (assuming that the window isnt maximized)." width="16" height="16" onclick="getHelp('xlproWidth.htm')" onmouseover="showReturns('Returns: Double')"><br><h2>LegendKey (1995) <img src="MSGBOX02.ICO" alt="Represents a legend key in a chart legend. Each legend key is a graphic that visually links a legend entry with its associated series or trendline in the chart. The legend key is linked to its associated series or trendline in such a way that changing the formatting of one simultaneously changes the formatting of the other." width="16" height="16" onclick="getHelp('xlobjLegendKey.htm');showMozHelp('Represents a legend key in a chart legend. Each legend key is a graphic that visually links a legend entry with its associated series or trendline in the chart. The legend key is linked to its associated series or trendline in such a way that changing the formatting of one simultaneously changes the formatting of the other.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Border<input type="image" src="MSGBOX02.ICO" alt="Returns: Border. This example sets the color of the chart area border of Chart1 to red." width="16" height="16" onclick="getHelp('xlproBorder.htm')" onmouseover="showReturns('Returns: Border')"><br>ClearFormats() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Clears the formatting of the object." width="16" height="16" onclick="getHelp('xlmthClearFormats.htm')" onmouseover="showReturns('Returns: Object')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Object')"><br>Fill<input type="image" src="MSGBOX02.ICO" alt="Returns: ChartFillFormat. Returns a FillFormat object that contains fill formatting properties for the specified chart or shape. Read-only." width="16" height="16" onclick="getHelp('xlproFill.htm')" onmouseover="showReturns('Returns: ChartFillFormat')"><br>Height<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. This example sets the height of the embedded chart." width="16" height="16" onclick="getHelp('xlproHeight.htm')" onmouseover="showReturns('Returns: Double')"><br>Interior<input type="image" src="MSGBOX02.ICO" alt="Returns: Interior. Interior property as it applies to the CellFormat object." width="16" height="16" onclick="getHelp('xlproInterior.htm')" onmouseover="showReturns('Returns: Interior')"><br>InvertIfNegative [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if Microsoft Excel inverts the pattern in the item when it corresponds to a negative number. Read/write Variant for the Interior object, read/write Boolean for all other objects." width="16" height="16" onclick="getHelp('xlproInvertIfNegative.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Left<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. If the window is maximized, Application.Left returns a negative number that varies based on the width of the window border. Setting Application.Left to 0 (zero) will make the window a tiny bit smaller than it would be if the application window were maximized. In other words, if Application.Left is 0 (zero), the left border of the main Microsoft Excel window will just barely be visible on the screen. " width="16" height="16" onclick="getHelp('xlproLeft.htm')" onmouseover="showReturns('Returns: Double')"><br>MarkerBackgroundColor [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the marker background color as an RGB value. Applies only to line, scatter, and radar charts. Read/write Long." width="16" height="16" onclick="getHelp('xlproMarkerBackgroundColor.htm')" onmouseover="showReturns('Returns: Int32')"><br>MarkerBackgroundColorIndex [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlColorIndex. Returns or sets the marker background color as an index into the current color palette, or as one of the following XlColorIndex constants: xlColorIndexAutomatic or xlColorIndexNone. Applies only to line, scatter, and radar charts. Read/write Long." width="16" height="16" onclick="getHelp('xlproMarkerBackgroundColorIndex.htm')" onmouseover="showReturns('Returns: XlColorIndex')"><br>MarkerForegroundColor [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the foreground color of the marker as an RGB value. Applies only to line, scatter, and radar charts. Read/write Long." width="16" height="16" onclick="getHelp('xlproMarkerForegroundColor.htm')" onmouseover="showReturns('Returns: Int32')"><br>MarkerForegroundColorIndex [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlColorIndex. Returns or sets the marker foreground color as an index into the current color palette, or as one of the following XlColorIndex constants: xlColorIndexAutomatic or xlColorIndexNone. Applies only to line, scatter, and radar charts. Read/write Long." width="16" height="16" onclick="getHelp('xlproMarkerForegroundColorIndex.htm')" onmouseover="showReturns('Returns: XlColorIndex')"><br>MarkerSize [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the data-marker size, in points. Read/write Long." width="16" height="16" onclick="getHelp('xlproMarkerSize.htm')" onmouseover="showReturns('Returns: Int32')"><br>MarkerStyle [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlMarkerStyle. This example sets the marker style for series one in Chart1. The example should be run on a 2-D line chart." width="16" height="16" onclick="getHelp('xlproMarkerStyle.htm')" onmouseover="showReturns('Returns: XlMarkerStyle')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>PictureType [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example sets series one in Chart1 to stretch pictures. The example should be run on a 2-D column chart with picture data markers." width="16" height="16" onclick="getHelp('xlproPictureType.htm')" onmouseover="showReturns('Returns: Int32')"><br>PictureUnit [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the unit for each picture on the chart if the PictureType property is set to xlScale (if not, this property is ignored). Read/write Long." width="16" height="16" onclick="getHelp('xlproPictureUnit.htm')" onmouseover="showReturns('Returns: Int32')"><br>Select() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Selects the object." width="16" height="16" onclick="getHelp('xlmthSelect.htm')" onmouseover="showReturns('Returns: Object')"><br>Shadow [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the font is a shadow font or if the object has a shadow. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproShadow.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Smooth [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if curve smoothing is turned on for the line chart or scatter chart. Applies only to line and scatter charts. Read/write." width="16" height="16" onclick="getHelp('xlproSmooth.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Top<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. The distance from the top edge of the screen to the top edge of the main Microsoft Excel window. If the application window is minimized, this property controls the position of the window icon (anywhere on the screen). Read/write Double." width="16" height="16" onclick="getHelp('xlproTop.htm')" onmouseover="showReturns('Returns: Double')"><br>Width<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. This example expands the active window to the maximum size available (assuming that the window isnt maximized)." width="16" height="16" onclick="getHelp('xlproWidth.htm')" onmouseover="showReturns('Returns: Double')"><br><h2>PlotArea (1995) <img src="MSGBOX02.ICO" alt="Represents the plot area of a chart. This is the area where your chart data is plotted. The plot area on a 2-D chart contains the data markers, gridlines, data labels, trendlines, and optional chart items placed in the chart area. The plot area on a 3-D chart contains all the above items plus the walls, floor, axes, axis titles, and tick-mark labels in the chart." width="16" height="16" onclick="getHelp('xlobjPlotArea.htm');showMozHelp('Represents the plot area of a chart. This is the area where your chart data is plotted. The plot area on a 2-D chart contains the data markers, gridlines, data labels, trendlines, and optional chart items placed in the chart area. The plot area on a 3-D chart contains all the above items plus the walls, floor, axes, axis titles, and tick-mark labels in the chart.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Border<input type="image" src="MSGBOX02.ICO" alt="Returns: Border. This example sets the color of the chart area border of Chart1 to red." width="16" height="16" onclick="getHelp('xlproBorder.htm')" onmouseover="showReturns('Returns: Border')"><br>ClearFormats() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Clears the formatting of the object." width="16" height="16" onclick="getHelp('xlmthClearFormats.htm')" onmouseover="showReturns('Returns: Object')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Fill<input type="image" src="MSGBOX02.ICO" alt="Returns: ChartFillFormat. Returns a FillFormat object that contains fill formatting properties for the specified chart or shape. Read-only." width="16" height="16" onclick="getHelp('xlproFill.htm')" onmouseover="showReturns('Returns: ChartFillFormat')"><br>Height [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. This example sets the height of the embedded chart." width="16" height="16" onclick="getHelp('xlproHeight.htm')" onmouseover="showReturns('Returns: Double')"><br>InsideHeight<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. Returns the inside height of the plot area, in points. Read-only Double." width="16" height="16" onclick="getHelp('xlproInsideHeight.htm')" onmouseover="showReturns('Returns: Double')"><br>InsideLeft<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. Returns the distance from the chart edge to the inside left edge of the plot area, in points. Read-only Double." width="16" height="16" onclick="getHelp('xlproInsideLeft.htm')" onmouseover="showReturns('Returns: Double')"><br>InsideTop<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. Returns the distance from the chart edge to the inside top edge of the plot area, in points. Read-only Double." width="16" height="16" onclick="getHelp('xlproInsideTop.htm')" onmouseover="showReturns('Returns: Double')"><br>InsideWidth<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. Returns the inside width of the plot area, in points. Read-only Double." width="16" height="16" onclick="getHelp('xlproInsideWidth.htm')" onmouseover="showReturns('Returns: Double')"><br>Interior<input type="image" src="MSGBOX02.ICO" alt="Returns: Interior. Interior property as it applies to the CellFormat object." width="16" height="16" onclick="getHelp('xlproInterior.htm')" onmouseover="showReturns('Returns: Interior')"><br>Left [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. If the window is maximized, Application.Left returns a negative number that varies based on the width of the window border. Setting Application.Left to 0 (zero) will make the window a tiny bit smaller than it would be if the application window were maximized. In other words, if Application.Left is 0 (zero), the left border of the main Microsoft Excel window will just barely be visible on the screen. " width="16" height="16" onclick="getHelp('xlproLeft.htm')" onmouseover="showReturns('Returns: Double')"><br>Name<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Name property and related properties given an OLAP data source with the unique name [Europe].[France].[Paris] and a non-OLAP data source with the item name Paris." width="16" height="16" onclick="getHelp('xlproName.htm')" onmouseover="showReturns('Returns: String')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Select() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Selects the object." width="16" height="16" onclick="getHelp('xlmthSelect.htm')" onmouseover="showReturns('Returns: Object')"><br>Top [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. The distance from the top edge of the screen to the top edge of the main Microsoft Excel window. If the application window is minimized, this property controls the position of the window icon (anywhere on the screen). Read/write Double." width="16" height="16" onclick="getHelp('xlproTop.htm')" onmouseover="showReturns('Returns: Double')"><br>Width [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. This example expands the active window to the maximum size available (assuming that the window isnt maximized)." width="16" height="16" onclick="getHelp('xlproWidth.htm')" onmouseover="showReturns('Returns: Double')"><br><h2>TickLabels (1995) <img src="MSGBOX02.ICO" alt="Represents the tick-mark labels associated with tick marks on a chart axis. This object isnt a collection. Theres no object that represents a single tick-mark label; you must return all the tick-mark labels as a unit." width="16" height="16" onclick="getHelp('xlobjTickLabels.htm');showMozHelp('Represents the tick-mark labels associated with tick marks on a chart axis. This object isnt a collection. Theres no object that represents a single tick-mark label; you must return all the tick-mark labels as a unit.');"></h2>Alignment [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. " width="16" height="16" onclick="getHelp('xlproAlignment.htm')" onmouseover="showReturns('Returns: Int32')"><br>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>AutoScaleFont [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. True if the text in the object changes font size when the object size changes. The default value is True. Read/write Variant." width="16" height="16" onclick="getHelp('xlproAutoScaleFont.htm')" onmouseover="showReturns('Returns: Object')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Object')"><br>Depth<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. For the ThreeDFormat object, returns or sets the depth of the shape's extrusion. Can be a value from &amp;nbsp;&amp;nbsp;600 through 9600 (positive values produce an extrusion whose front face is the original shape; negative values produce an extrusion whose back face is the original shape). Read/write Single." width="16" height="16" onclick="getHelp('xlproDepth.htm')" onmouseover="showReturns('Returns: Int32')"><br>Font<input type="image" src="MSGBOX02.ICO" alt="Returns: Font. Font property as it applies to the CellFormat object." width="16" height="16" onclick="getHelp('xlproFont.htm')" onmouseover="showReturns('Returns: Font')"><br>Name<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Name property and related properties given an OLAP data source with the unique name [Europe].[France].[Paris] and a non-OLAP data source with the item name Paris." width="16" height="16" onclick="getHelp('xlproName.htm')" onmouseover="showReturns('Returns: String')"><br>NumberFormat [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. NumberFormat property as it applies to the DataLabel, DataLabels, PivotField, Style, and TickLabels objects." width="16" height="16" onclick="getHelp('xlproNumberFormat.htm')" onmouseover="showReturns('Returns: String')"><br>NumberFormatLinked [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the number format is linked to the cells (so that the number format changes in the labels when it changes in the cells). Read/write Boolean." width="16" height="16" onclick="getHelp('xlproNumberFormatLinked.htm')" onmouseover="showReturns('Returns: Boolean')"><br>NumberFormatLocal [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. NumberFormatLocal property as it applies to the Style object." width="16" height="16" onclick="getHelp('xlproNumberFormatLocal.htm')" onmouseover="showReturns('Returns: Object')"><br>Offset [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns a Range object that represents a range thats offset from the specified range. Read-only." width="16" height="16" onclick="getHelp('xlproOffset.htm')" onmouseover="showReturns('Returns: Int32')"><br>Orientation [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlTickLabelOrientation. For OLAP data sources, setting this property for one field in a hierarchy sets the orientation for the other fields in the same hierarchy. Dimension fields can only be oriented in the row, column, and page field areas of the PivotTable report. Measure fields can only be oriented in the data area. Setting a hierarchy or data field to xlHidden removes the hierarchy or field from the PivotTable report." width="16" height="16" onclick="getHelp('xlproOrientation.htm')" onmouseover="showReturns('Returns: XlTickLabelOrientation')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>ReadingOrder [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the reading order for the specified object. Can be one of the following constants: xlRTL (right-to-left), xlLTR (left-to-right), or xlContext. Read/write Long." width="16" height="16" onclick="getHelp('xlproReadingOrder.htm')" onmouseover="showReturns('Returns: Int32')"><br>Select() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Selects the object." width="16" height="16" onclick="getHelp('xlmthSelect.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>Trendline (1995) <img src="MSGBOX02.ICO" alt="Represents a trendline in a chart. A trendline shows the trend, or direction, of data in a series. The Trendline object is a member of the Trendlines collection. The Trendlines collection contains all the Trendline objects for a single series." width="16" height="16" onclick="getHelp('xlobjTrendline.htm');showMozHelp('Represents a trendline in a chart. A trendline shows the trend, or direction, of data in a series. The Trendline object is a member of the Trendlines collection. The Trendlines collection contains all the Trendline objects for a single series.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Backward [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the number of periods (or units on a scatter chart) that the trendline extends backward. Read/write Long" width="16" height="16" onclick="getHelp('xlproBackward.htm')" onmouseover="showReturns('Returns: Int32')"><br>Border<input type="image" src="MSGBOX02.ICO" alt="Returns: Border. This example sets the color of the chart area border of Chart1 to red." width="16" height="16" onclick="getHelp('xlproBorder.htm')" onmouseover="showReturns('Returns: Border')"><br>ClearFormats() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Clears the formatting of the object." width="16" height="16" onclick="getHelp('xlmthClearFormats.htm')" onmouseover="showReturns('Returns: Object')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>DataLabel<input type="image" src="MSGBOX02.ICO" alt="Returns: DataLabel. Returns a DataLabel object that represents the data label associated with the point or trendline. Read-only." width="16" height="16" onclick="getHelp('xlproDataLabel.htm')" onmouseover="showReturns('Returns: DataLabel')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Object')"><br>DisplayEquation [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the equation for the trendline is displayed on the chart (in the same data label as the R-squared value). Setting this property to True automatically turns on data labels. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproDisplayEquation.htm')" onmouseover="showReturns('Returns: Boolean')"><br>DisplayRSquared [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the R-squared value of the trendline is displayed on the chart (in the same data label as the equation). Setting this property to True automatically turns on data labels. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproDisplayRSquared.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Forward [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the number of periods (or units on a scatter chart) that the trendline extends forward. Read/write Long." width="16" height="16" onclick="getHelp('xlproForward.htm')" onmouseover="showReturns('Returns: Int32')"><br>Index<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. For information about using the Index worksheet function in Visual Basic, see Using Worksheet Functions in Visual Basic." width="16" height="16" onclick="getHelp('xlproIndex.htm')" onmouseover="showReturns('Returns: Int32')"><br>Intercept [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Double. Returns or sets the point where the trendline crosses the value axis. Read/write Double." width="16" height="16" onclick="getHelp('xlproIntercept.htm')" onmouseover="showReturns('Returns: Double')"><br>InterceptIsAuto [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if the point where the trendline crosses the value axis is automatically determined by the regression. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproInterceptIsAuto.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Name [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Name property and related properties given an OLAP data source with the unique name [Europe].[France].[Paris] and a non-OLAP data source with the item name Paris." width="16" height="16" onclick="getHelp('xlproName.htm')" onmouseover="showReturns('Returns: String')"><br>NameIsAuto [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Boolean. True if Microsoft Excel automatically determines the name of the trendline. Read/write Boolean." width="16" height="16" onclick="getHelp('xlproNameIsAuto.htm')" onmouseover="showReturns('Returns: Boolean')"><br>Order [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example breaks Sheet1 into pages when the worksheet is printed. Numbering and printing proceed from the first page to the pages to the right, and then move down and continue printing across the sheet." width="16" height="16" onclick="getHelp('xlproOrder.htm')" onmouseover="showReturns('Returns: Int32')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Period [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. Returns or sets the period for the moving-average trendline. Read/write Long." width="16" height="16" onclick="getHelp('xlproPeriod.htm')" onmouseover="showReturns('Returns: Int32')"><br>Select() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Selects the object." width="16" height="16" onclick="getHelp('xlmthSelect.htm')" onmouseover="showReturns('Returns: Object')"><br>Type [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: XlTrendlineType. Returns or sets the Axis type. Read/write XlAxisType." width="16" height="16" onclick="getHelp('xlproType.htm')" onmouseover="showReturns('Returns: XlTrendlineType')"><br><h2>Trendlines (1995) <img src="MSGBOX02.ICO" alt="A collection of all the Trendline objects for the specified series. Each Trendline object represents a trendline in a chart. A trendline shows the trend, or direction, of data in a series." width="16" height="16" onclick="getHelp('xlobjTrendlines.htm');showMozHelp('A collection of all the Trendline objects for the specified series. Each Trendline object represents a trendline in a chart. A trendline shows the trend, or direction, of data in a series.');"></h2>Add([Type], [Order], [Period], [Forward], [Backward], [Intercept], [DisplayEquation], [DisplayRSquared], [Name]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Trendline. If a style with the specified name already exists, this method redefines the existing style based on the cell specified in BasedOn. The following example redefines the Normal style based on the active cell." width="16" height="16" onclick="getHelp('xlmthAdd.htm')" onmouseover="showReturns('Returns: Trendline')"><br>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Count<input type="image" src="MSGBOX02.ICO" alt="Returns: Int32. This example displays the number of columns in the selection on Sheet1. The code also tests for a multiple-area selection; if one exists, the code loops on the areas of the multiple-area selection." width="16" height="16" onclick="getHelp('xlproCount.htm')" onmouseover="showReturns('Returns: Int32')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>GetEnumerator() <input type="image" src="MSGBOX02.ICO" alt="Returns: IEnumerator. Hidden or unsupported element." width="16" height="16" onclick="getHelp('unsupported.htm')" onmouseover="showReturns('Returns: IEnumerator')"><br>Item([Index]) <input type="image" src="MSGBOX02.ICO" alt="Returns: Trendline. The text name of the object is the value of the Caption property." width="16" height="16" onclick="getHelp('xlmthItem.htm')" onmouseover="showReturns('Returns: Trendline')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>UpBars (1995) <img src="MSGBOX02.ICO" alt="Represents the up bars in a chart group. Up bars connect points on series one with higher values on the last series in the chart group (the lines go up from series one). Only 2-D line groups that contain at least two series can have up bars. This object isnt a collection. Theres no object that represents a single up bar; you either have up bars turned on for all points in a chart group or you have them turned off." width="16" height="16" onclick="getHelp('xlobjUpBars.htm');showMozHelp('Represents the up bars in a chart group. Up bars connect points on series one with higher values on the last series in the chart group (the lines go up from series one). Only 2-D line groups that contain at least two series can have up bars. This object isnt a collection. Theres no object that represents a single up bar; you either have up bars turned on for all points in a chart group or you have them turned off.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Border<input type="image" src="MSGBOX02.ICO" alt="Returns: Border. This example sets the color of the chart area border of Chart1 to red." width="16" height="16" onclick="getHelp('xlproBorder.htm')" onmouseover="showReturns('Returns: Border')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Delete() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Deleting a Point or LegendKey object deletes the entire series." width="16" height="16" onclick="getHelp('xlmthDelete.htm')" onmouseover="showReturns('Returns: Object')"><br>Fill<input type="image" src="MSGBOX02.ICO" alt="Returns: ChartFillFormat. Returns a FillFormat object that contains fill formatting properties for the specified chart or shape. Read-only." width="16" height="16" onclick="getHelp('xlproFill.htm')" onmouseover="showReturns('Returns: ChartFillFormat')"><br>Interior<input type="image" src="MSGBOX02.ICO" alt="Returns: Interior. Interior property as it applies to the CellFormat object." width="16" height="16" onclick="getHelp('xlproInterior.htm')" onmouseover="showReturns('Returns: Interior')"><br>Name<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Name property and related properties given an OLAP data source with the unique name [Europe].[France].[Paris] and a non-OLAP data source with the item name Paris." width="16" height="16" onclick="getHelp('xlproName.htm')" onmouseover="showReturns('Returns: String')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Select() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Selects the object." width="16" height="16" onclick="getHelp('xlmthSelect.htm')" onmouseover="showReturns('Returns: Object')"><br><h2>Walls (1995) <img src="MSGBOX02.ICO" alt="Represents the walls of a 3-D chart. This object isnt a collection. Theres no object that represents a single wall; you must return all the walls as a unit." width="16" height="16" onclick="getHelp('xlobjWalls.htm');showMozHelp('Represents the walls of a 3-D chart. This object isnt a collection. Theres no object that represents a single wall; you must return all the walls as a unit.');"></h2>Application<input type="image" src="MSGBOX02.ICO" alt="Returns: Application. Used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. Used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return that object's application). Read-only." width="16" height="16" onclick="getHelp('xlproApplication.htm')" onmouseover="showReturns('Returns: Application')"><br>Border<input type="image" src="MSGBOX02.ICO" alt="Returns: Border. This example sets the color of the chart area border of Chart1 to red." width="16" height="16" onclick="getHelp('xlproBorder.htm')" onmouseover="showReturns('Returns: Border')"><br>ClearFormats() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Clears the formatting of the object." width="16" height="16" onclick="getHelp('xlmthClearFormats.htm')" onmouseover="showReturns('Returns: Object')"><br>Creator<input type="image" src="MSGBOX02.ICO" alt="Returns: XlCreator. The Creator property is designed to be used in Microsoft Excel for the Macintosh, where each application has a four-character creator code. For example, Microsoft Excel has the creator code XCEL." width="16" height="16" onclick="getHelp('xlproCreator.htm')" onmouseover="showReturns('Returns: XlCreator')"><br>Fill<input type="image" src="MSGBOX02.ICO" alt="Returns: ChartFillFormat. Returns a FillFormat object that contains fill formatting properties for the specified chart or shape. Read-only." width="16" height="16" onclick="getHelp('xlproFill.htm')" onmouseover="showReturns('Returns: ChartFillFormat')"><br>Interior<input type="image" src="MSGBOX02.ICO" alt="Returns: Interior. Interior property as it applies to the CellFormat object." width="16" height="16" onclick="getHelp('xlproInterior.htm')" onmouseover="showReturns('Returns: Interior')"><br>Name<input type="image" src="MSGBOX02.ICO" alt="Returns: String. The following table shows example values of the Name property and related properties given an OLAP data source with the unique name [Europe].[France].[Paris] and a non-OLAP data source with the item name Paris." width="16" height="16" onclick="getHelp('xlproName.htm')" onmouseover="showReturns('Returns: String')"><br>Parent<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns the parent object for the specified object." width="16" height="16" onclick="getHelp('xlproParent.htm')" onmouseover="showReturns('Returns: Object')"><br>Paste() <input type="image" src="MSGBOX02.ICO" alt="Returns: Void. Pastes chart data from the Clipboard into the specified chart." width="16" height="16" onclick="getHelp('xlmthPaste.htm')" onmouseover="showReturns('Returns: Void')"><br>PictureType [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. This example sets series one in Chart1 to stretch pictures. The example should be run on a 2-D column chart with picture data markers." width="16" height="16" onclick="getHelp('xlproPictureType.htm')" onmouseover="showReturns('Returns: Object')"><br>PictureUnit [= setting]<input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Returns or sets the unit for each picture on the chart if the PictureType property is set to xlScale (if not, this property is ignored). Read/write Long." width="16" height="16" onclick="getHelp('xlproPictureUnit.htm')" onmouseover="showReturns('Returns: Object')"><br>Select() <input type="image" src="MSGBOX02.ICO" alt="Returns: Object. Selects the object." width="16" height="16" onclick="getHelp('xlmthSelect.htm')" onmouseover="showReturns('Returns: Object')"><br></body> </html>