Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting the minimum/maximum display range of a chart Babymech Excel Discussion (Misc queries) 3 March 16th 09 11:07 AM
Excel Addin:Setting the range to the Excel.Range object range prop Rp007 Excel Worksheet Functions 5 November 24th 06 04:30 PM
VBA setting Range Jeff Excel Discussion (Misc queries) 1 December 2nd 05 07:36 PM
range setting Mike Harris Excel Programming 5 November 22nd 03 05:07 AM
Setting a range using VBA [email protected] Excel Programming 4 November 14th 03 05:16 AM


All times are GMT +1. The time now is 06:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"