Posted to microsoft.public.excel.programming

Andrew[_9_] Andrew[_9_] is offline

external usenet poster

Posts: 30

How to set Chart SetSourceData in code..?

I have...

Worksheet("Sheet1")
r1, c1, r2, c2 As Integer

r1 = 24: c1 = 2: r2 = 68: c2 = 2

Charts("Chart1").SeriesCollection(1).Values =
Worksheets("Sheet1").Range(Cells(r1, c1), Cells(r2,c2))

r1 & r2 will change according to user interaction in other code.
What have i missed..?

Any help would be greatly appreciated. ;)

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
I think the problem is in .SetSourceData ??	keith	Excel Programming	2	April 20th 09 12:53 PM
setSourcedata	tony wong	Excel Programming	2	February 22nd 07 02:06 PM
Series.Values vs Chart.SetSourceData	Hans	Excel Programming	2	January 20th 06 11:19 AM
SetSourceData for Chart	Doerte	Excel Programming	2	November 29th 04 11:55 AM

All times are GMT +1. The time now is 04:47 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us