Two types of graphs on same chart?

[dahler]

Is it possible to have two types of graphs on one chart?



I would like på make a ColumnStacked graph, and on the same chart have a
horizontal line, being a kind of limit, so that I can se, which columns
are below the limit, and which are above.



Is it possible? Can anyone help me, how to do this?



Thanks,

/Dahler

 

[Sean]

All you have to do is set up two different
SeriesCollections. Look at the following example:

'Add a series to the chart with the x-values and y-
values
Dim oSeries
Set oSeries = oChart.SeriesCollection.Add
oSeries.SetData c.chDimCategories, c.chDataLiteral,
xValues
oSeries.SetData c.chDimValues, c.chDataLiteral,
yValues1
oSeries.Type = c.chChartTypeColumnClustered


'Add another series to the chart with the x-values
and second y-values
'from the arrays and set the series type to a line
chart.
Set oSeries = oChart.SeriesCollection.Add
oSeries.SetData c.chDimCategories, c.chDataLiteral,
xValues
oSeries.SetData c.chDimValues, c.chDataLiteral,
yValues2
oSeries.Type = c.chChartTypeSmoothLine