Combine series from different data sources into one.
QUESTION
How can data from two different database sources be combined into a single series?
ANSWER
The first step is to use the DataEngine to get your data into two separate series. Please see this kb for more info.
To combine the two series into one, the following code can be used:
| [C#]
Series mySeries = new Series()
mySeries.Elements.Add(seriesOne.Elements);
mySeries.Elements.Add(seriesTwo.Elements);
Chart.SeriesCollection.Add(mySeries);
|
| [Visual Basic]
Dim mySeries As New Series()
mySeries.Elements.Add(seriesOne.Elements)
mySeries.Elements.Add(seriesTwo.Elements)
Chart.SeriesCollection.Add(mySeries)
|