Skip to content

Files

Latest commit

author
Docs Allowlist Management
Mar 29, 2024
128e4d7 · Mar 29, 2024

History

History
43 lines (22 loc) · 978 Bytes

Excel.sparklinegroup.plotby.md

File metadata and controls

43 lines (22 loc) · 978 Bytes
title keywords f1_keywords ms.assetid ms.date ms.localizationpriority
SparklineGroup.PlotBy property (Excel)
vbaxl10.chm871091
vbaxl10.chm871091
217c6de7-fabf-2642-96a7-aec82f6609a9
05/16/2019
medium

SparklineGroup.PlotBy property (Excel)

Returns or sets how to plot the sparkline when the data on which it is based is in a square-shaped range. Read/write.

Syntax

expression.PlotBy

expression A variable that represents a SparklineGroup object.

Return value

XlSparklineRowCol

Remarks

This property can only be set if the data on which the sparkline is based is in a square-shaped range, for example if the data is in the range A1:B2.

The default value for sp data in a square-shaped range is to plot the data by rows (xlSparklineRowsSquare).

Property value

XLSPARKLINEROWCOL

[!includeSupport and feedback]