Format related procedures in class Series (PowerPoint VBA)

This page presents procedures from class Series related to the theme Format: ClearFormats, Format, InvertColor, InvertColorIndex, MarkerBackgroundColor, MarkerBackgroundColorIndex, MarkerForegroundColor, MarkerForegroundColorIndex, MarkerStyle and PlotColorIndex

ClearFormats

Clears the formatting of the object.

ActiveWindow.RangeFromPoint.Chart.FullSeriesCollection(1).ClearFormats

Format

Returns the line, fill, and effect formatting for the object.

Dim cftFormatted As ChartFormat
Set cftFormatted = ActiveWindow.RangeFromPoint.Chart.FullSeriesCollection(1).Format

InvertColor

Returns or sets the fill color for negative data points in a series.

The InvertColor property enables you to set the fill color for negative data points as a specific numeric, hexadecimal, octal, or RGB color value. To set the value as an RBG value, use the Visual Basic RGB function. Instead of using the InvertColor property, you can use the InvertColorIndex property, which uses a simplier set of integer values from the current color palette. For the InvertColor property to have an effect, the InvertIfNegative property of the Series object must also be set to True.

ActivePresentation.Slides(1).Shapes(1).Chart.FullSeriesCollection(1).InvertColor = RGB(0,0,255)'blue

InvertColorIndex

Returns or sets the fill color for negative data points in a series.

Possible Values are xlColorIndexAutomatic - Automatic color, xlColorIndexNone - No color.

The InvertColorIndex property enables you to set the fill color for negative data points as a color index value from 0 to 56. Instead of using the InvertColorIndex property, you can use the InvertColor property, which enables you to set the color as a specific numeric, hexadecimal, octal, or RGB color value. For the InvertColorIndex property to have an effect, the InvertIfNegative property of the Series object must also be set to True.

ActivePresentation.Slides(1).Shapes(1).Chart.FullSeriesCollection(1).InvertColorIndex = RGB(0,0,255)'blue

MarkerBackgroundColor

Sets the marker background color as an RGB value or returns the corresponding color index value.

This property applies only to line, scatter, and radar charts.

ActiveWindow.RangeFromPoint.Chart.FullSeriesCollection(1).MarkerBackgroundColor = RGB(0,0,255)'blue

MarkerBackgroundColorIndex

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.

Possible Values are xlColorIndexAutomatic - Automatic color, xlColorIndexNone - No color.

This property applies only to line, scatter, and radar charts.

ActiveWindow.RangeFromPoint.Chart.FullSeriesCollection(1).MarkerBackgroundColorIndex = xlColorIndexAutomatic

MarkerForegroundColor

Sets the marker foreground color as an RGB value or returns the corresponding color index value.

This property applies only to line, scatter, and radar charts.

ActiveWindow.RangeFromPoint.Chart.FullSeriesCollection(1).MarkerForegroundColor = RGB(0,0,255)'blue

MarkerForegroundColorIndex

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.

Possible Values are xlColorIndexAutomatic - Automatic color, xlColorIndexNone - No color.

This property applies only to line, scatter, and radar charts.

ActiveWindow.RangeFromPoint.Chart.FullSeriesCollection(1).MarkerForegroundColorIndex = xlColorIndexAutomatic

MarkerStyle

Returns or sets the marker style for a point or series in a line chart, scatter chart, or radar chart.

Possible Values are xlMarkerStyleAutomatic - Automatic markers, xlMarkerStyleCircle - Circular markers, xlMarkerStyleDash - Long bar markers, xlMarkerStyleDiamond - Diamond-shaped markers, xlMarkerStyleDot - Short bar markers, xlMarkerStyleNone - No markers, xlMarkerStylePicture - Picture markers, xlMarkerStylePlus - Square markers with a plus sign, xlMarkerStyleSquare - Square markers, xlMarkerStyleStar - Square markers with an asterisk, xlMarkerStyleTriangle - Triangular markers, xlMarkerStyleX - Square markers with an X.
ActivePresentation.Slides(1).Shapes(1).Chart.FullSeriesCollection(1).MarkerStyle = xlMarkerStyleAutomatic

PlotColorIndex

Returns an index value that is used internally to associate series formatting with chart elements.

This property is used internally by Microsoft PowerPoint and is not intended to be called from your code.

Dim lngPlotColorIndex As Long
lngPlotColorIndex = ActiveWindow.RangeFromPoint.Chart.FullSeriesCollection(1).PlotColorIndex