从数组数据而不是范围创建图表 [英] Create Chart from Array data and not range

问题描述

是否可以不从范围而是从数组数据创建图表(例如双 Y 轴折线图)?如果是，怎么办?

is it possible to create a Chart (e.g. Double Y-Axis Line Chart) not from Ranges, but from Array data? If so, how?

推荐答案

是的.您可以将数组分配给图表上 Series 对象的 XValues 和 Values 属性.示例:

Yes. You can assign arrays to the XValues and Values properties of a Series object on a chart. Example:

Dim c As Chart
Dim s As Series
Dim myData As Variant

Set c = ActiveChart ' Assumes a chart is currently active in Excel...
Set s = c.SeriesCollection(1)

myData = Array(9, 6, 7, 1) ' or whatever
s.Values = myData

这篇关于从数组数据而不是范围创建图表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！