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

Some information he

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

--
Regards,
Tom Ogilvy


"David" wrote:

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