Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting the range in a chart using VB
Hi
My VB code calls a C++ dll and gets a Variant array with double back. The number of points in the array changes every time and I want a chart to display them. Can anyone give me any hint as to how to feed the right range into a chart using VB Thanks Torben |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting the range in a chart using VB
This is something my I guy came up with
Sub Update_Chart( Dim stRange As String, endrow As Intege endrow = Range("a1").End(xlDown).ro stRange = "a1:b" & endro ActiveSheet.ChartObjects("Chart 1").Activat ActiveChart.SetSourceData Source:=Range(stRange), PlotBy :=xlColumn Range("a1").Selec End Su |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting the minimum/maximum display range of a chart | Excel Discussion (Misc queries) | |||
Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
VBA setting Range | Excel Discussion (Misc queries) | |||
range setting | Excel Programming | |||
Setting a range using VBA | Excel Programming |