Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all.
From a sheet with sourcedata I generate graphs for each row. Right now I am changing a simple graph to a two-series graph where for each row-iteration I have to change the series, for example to:. I need two series that take data from the same row: Series A: (E3;H3;K3;N3;Q3;T3;W3;Z3;AC3;AF3;AI3;AL3) Series B: (C3;F3;I3;L3;O3;R3;U3;X3;AA3;AD3;AG3;AJ3) When setting the ranges manually all works well. However I get an error when assigning the range to the series: series.values = "E3;H3;K3;N3;Q3;T3;W3;Z3;AC3;AF3;AI3;AL3" In the simple graph I assigned that same string to chart.SetSourceData() which worked fine. It looks as if I am unable to specify separate cells in that range, as a range of "A1:A10" works well. Does anyone have a clue how to get these separate cells assigned to the series? Thanx in advance. Hans |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
In Office 2007 can't see chart series values unless chart unprotec | Charts and Charting in Excel | |||
Add values to a series in a chart | Charts and Charting in Excel | |||
SetSourceData for UserType XYChart with two series | Charts and Charting in Excel | |||
Chart -- How to chart 65536 values in 1 series? | About this forum | |||
SetSourceData for Chart | Excel Programming |