【GH】【EXCEL】P4: Chart

本文主要是介绍【GH】【EXCEL】P4: Chart，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

文章目录

data and chart
- donut chart (radial chart)
- - Radial Chart
- bar chart
- - Bar Chart
- line chart
- - Line Chart
- Scatter Chart
- - Scatter Chart
- Surface Chart
- - Surface Chart
- Chart Decorators
- - Chart Decorators
- Chart Graphics
- - Chart Graphics

data and chart

donut chart (radial chart)

A Chart object can be quickly added to a Worksheet by referencing data from a Range

Radial Chart

Add a Radial Chart object

Input parameters:

Worksheet (Generic Data) A Worksheet, Workbook, Range Object, Excel Application, or Text Worksheet Name

Range (Generic Data) A Range Object or Text Address (ex. A1:B1)

Name (Text) The title of the chart

Boundary (Rectangle) The Shape bounding rectangle

Flip (Boolean) If true, the data will be read by column

Chart Type (Integer) The chart type

Pie
Pie3D
Donut
Radar
Radar Filled

Activate (Boolean) If true, the component will be activated

Output parameters:

Range (Generic Data) An Excel Range Object
Chart (Generic Data) A Chart object

bar chart

Chart graphics can be updated by series or by cell.

Bar Chart

Add a Bar Chart object

Input parameters:

Worksheet (Generic Data) A Worksheet, Workbook, Range Object, Excel Application, or Text Worksheet Name

Range (Generic Data) A Range Object or Text Address (ex. A1:B1)

Name (Text) The title of the chart

Boundary (Rectangle) The Shape bounding rectangle

Flip (Boolean) If true, the data will be read by column

Chart Type (Integer) The chart type

Basic
Box
Pyramid
Cylinder
Cone

Alignment Type (Integer) The chart alignment type

Cluster
Stack
Fill

Activate (Boolean) If true, the component will be activated

Output parameters:

Range (Generic Data) An Excel Range Object
Chart (Generic Data) A Chart object

line chart

Chart properties can be modified on a placed Chart.

Line Chart

Add a Line Chart object

Input parameters:

Worksheet (Generic Data) A Worksheet, Workbook, Range Object, Excel Application, or Text Worksheet Name

Range (Generic Data) A Range Object or Text Address (ex. A1:B1)

Name (Text) The title of the chart

Boundary (Rectangle) The Shape bounding rectangle

Flip (Boolean) If true, the data will be read by column

Chart Type (Integer) The chart type

Line
LineMarkers
Area
Area3d

Alignment Type (Integer) The chart alignment type

Cluster
Stack
Fill

Activate (Boolean) If true, the component will be activated

Output parameters:

Range (Generic Data) An Excel Range Object
Chart (Generic Data) A Chart object

Scatter Chart

Scatter Chart

Add a Scatter Chart object

Input parameters:

Worksheet (Generic Data) A Worksheet, Workbook, Range Object, Excel Application, or Text Worksheet Name

Range (Generic Data) A Range Object or Text Address (ex. A1:B1)

Name (Text) The title of the chart

Boundary (Rectangle) The Shape bounding rectangle

Flip (Boolean) If true, the data will be read by column

Chart Type (Integer) The chart type

Scatter
Scatter Lines
Scatter Smooth
Bubble
Bubble 3D

Activate (Boolean) If true, the component will be activated

Output parameters:

Range (Generic Data) An Excel Range Object
Chart (Generic Data) A Chart object

Surface Chart

Surface Chart

Add a Surface Chart object

Input parameters:

Worksheet (Generic Data) A Worksheet, Workbook, Range Object, Excel Application, or Text Worksheet Name

Range (Generic Data) A Range Object or Text Address (ex. A1:B1)

Name (Text) The title of the chart

Boundary (Rectangle) The Shape bounding rectangle

Flip (Boolean) If true, the data will be read by column

Chart Type (Integer) The chart type

Surface
SurfaceVireframe
SurfaceTop
SurfaceWireframeTop

Activate (Boolean) If true, the component will be activated

Output parameters:

Range (Generic Data) An Excel Range Object
Chart (Generic Data) A Chart object

Chart Decorators

Chart Decorators

Update Chart Decorations

Input parameters:

Chart (Generic Data) A Chart object
Title (Text) Title
Legend Location (Integer) The location of the legend
Data Label (Integer) The data label type
Grid X (Integer) The X axis Grid settings
Grid Y (Integer) The Y axis Grid settings
Axis X (Text) An optional X axis label
Axis Y (Text) An optional Y axis label

Output parameters:

Chart (Generic Data) A Chart object

Chart Graphics

Chart Graphics

Update Chart Graphics

Input parameters:
Chart (Generic Data) A Chart object

By Series (Boolean) If true, values are plotted by series otherwise colors will be by point

Fill Colors (Colour) Chart fill colors S

troke Colors (Colour) Chart stroke colors S

troke Weights (Integer) Chart stroke weights 0-3