VBA Excel-从内存设置图表数据 [英] VBA Excel - Setting Chart data from memory

问题描述

在Excel中，可以通过VBA从保存在内存中的数据设置图表数据吗?例如，如果您在VBA [1,2,3,4,5,6 ...]中创建了一个数组，那么您可以在工作簿中显示一个图表吗?

In Excel, via VBA, is it possible to set chart data from data that is held in memory? For example, if you created an array in VBA [1,2,3,4,5,6...], can you have a chart in the workbook display that?

谢谢-KC

推荐答案

是的，这是一个简单的示例...

Yes, here's a simple example...

Sub test()

    Dim vXVals As Variant
    Dim vVals As Variant

    vXVals = Array("Wk1", "Wk2", "Wk3")
    vVals = Array(100, 175, 150)

    With ActiveSheet.ChartObjects.Add(Left:=Range("B2").Left, Top:=Range("B2").Top, Width:=360, Height:=210).Chart
        With .SeriesCollection.NewSeries
            .Name = "Series Name"
            .XValues = vXVals
            .Values = vVals
        End With
    End With

End Sub

希望这会有所帮助！

这篇关于VBA Excel-从内存设置图表数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！