내보내기(0) 인쇄
모두 확장
이 항목은 아직 평가되지 않았습니다.- 이 항목 평가

SeriesCollection.Paste Method (Excel)

Office 2010

Pastes data from the Clipboard into the specified series collection.

.Paste(Rowcol, SeriesLabels, CategoryLabels, Replace, NewSeries)

A variable that represents a SeriesCollection object.

Parameters

Name

Required/Optional

Data Type

Description

Rowcol

선택

XlRowCol (영문)

. Specifies whether the values corresponding to a particular data series are in rows or columns.

SeriesLabels

선택

Variant

True to use the contents of the cell in the first column of each row (or the first row of each column) as the name of the data series in that row (or column). False to use the contents of the cell in the first column of each row (or the first row of each column) as the first data point in the data series. The default value is False.

CategoryLabels

선택

Variant

True to use the contents of the first row (or column) of the selection as the categories for the chart. False to use the contents of the first row (or column) as the first data series in the chart. The default value is False.

Replace

선택

Variant

True to apply categories while replacing existing categories with information from the copied range. False to insert new categories without replacing any old ones. The default value is True.

NewSeries

선택

Variant

True to paste the data as a new series. False to paste the data as new points in an existing series. The default value is True.

Return Value

Variant

This example pastes data from the Clipboard into a new series in Chart1.

Worksheets("Sheet1").Range("C1:C5").Copy 
Charts("Chart1").SeriesCollection.Paste
이 정보가 도움이 되었습니까?
(1500자 남음)
의견을 주셔서 감사합니다.
표시:
© 2014 Microsoft. All rights reserved.