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 here:

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