LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 120
Default SetSourceData for UserType XYChart with two series

Jon and the others,
Imagine I am to depict routinely series of recorded points by means of a
user defined chart, where one chart series are the mentioned points, and
another one is a user defined regression function. As I do not intend to
stuff numerous sheets in a workbook with excessive charts, I would prefer
macro that is able to present, promptly and temporarily, a neatly formatted
user chart, fed with actual values. When using usual commands

Charts.Add
ActiveChart.ApplyCustomType ChartType:=xlUserDefined, TypeName:= . . .

the conflict, however, comes in:

ActiveChart.SetSourceData Source:= . . .

Assigning a simple (double-)block for the first of the series is trivial
here. But the second series, though primarily contained in the template
chart, virtually disappears and thus cannot be declared by a following
..SeriesCollection(2). It requires adding the second Series, with necessary
loss of original format.
An idea arises that - if the Source:= could be declared as to comprise both
of data series by some sort of Range combinations or so - the problem would
be solved. Has somebody sought such a solution?
As a remark, my way out now is copying the template chart from a workbook
with getting data from the actual worksheet. But still I succumbed to a
temptation to seek a smart idea.
Sorry for my submitting marginal topics.

Petr
 
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
Fill Series Dates: not letting me change the series from year to m Mike Excel Discussion (Misc queries) 1 January 24th 08 05:08 PM
defined names and setsourcedata Jason Morin Charts and Charting in Excel 2 December 5th 07 03:39 PM
charting problem with activechart.setsourcedata Mary Kathryn Excel Discussion (Misc queries) 4 February 25th 06 08:54 PM
chart data series -- plot a table as a single series hjc Charts and Charting in Excel 7 September 20th 05 05:52 PM
series graph -- one series being added to another series rich zielinski via OfficeKB.com Charts and Charting in Excel 3 March 30th 05 06:23 PM


All times are GMT +1. The time now is 08:23 PM.

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

About Us

"It's about Microsoft Excel"