Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to append existing series?
I want to append specific series on a chart.
I realize using the extend method would do the trick, but that will append all the series in the chart.Hence the format SeriesCollection.Extend I want to be able to extend specific series so SeriesCollection(index).Extend, but it gives me a runtime error when using that code. Anyone know how would I extend an existing specific series? -- Message posted via http://www.officekb.com |
#2
|
|||
|
|||
If you know the range that constitutes the source for a particular
series set the Values (and XValues) properties. Something like: ActiveChart.SeriesCollection(1).Values = _ "='" & ActiveSheet.Name & "'!" _ & Range("F1").Resize(4, 1).Address( _ RowAbsolute:=True, ColumnAbsolute:=True, _ ReferenceStyle:=xlR1C1) Or you can use named formulas for series a la Dynamic Charts http://www.tushar-mehta.com/excel/ne...rts/index.html -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I want to append specific series on a chart. I realize using the extend method would do the trick, but that will append all the series in the chart.Hence the format SeriesCollection.Extend I want to be able to extend specific series so SeriesCollection(index).Extend, but it gives me a runtime error when using that code. Anyone know how would I extend an existing specific series? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to hide a dummy series in a chart legend? | New Users to Excel | |||
Can I add an average series to a chart with 2 or more series? | Charts and Charting in Excel | |||
How to change Series order in a Combination Chart? | Charts and Charting in Excel | |||
How to change Series Order in a Combination Chart? | Excel Discussion (Misc queries) | |||
series graph -- one series being added to another series | Charts and Charting in Excel |