Add to Chart

[Guest]

Hello

I have a number of sets of data that create simple line charts.
I would like the user to be able to select a custom set to add extra lines
to a chart.
I just dont know how I can capture the data source from the chart so that I
can add extra lines to it.

eg
Private Sub ButtonX_Click

Dim ChartSource As String
ChartSource = Chart1.?datasource?

ChartSource = ChartSource + "F4:F15"

End Sub

Does this make sense?

David

 

[Guest]

Some information here:

http://www.j-walk.com/ss/excel/tips/tip83.htm