I have a 2 columns of data which can vary in length.

Is it possible to create a chart where you only have the start range but not
an end range.

Example:

1 5
2 1
3 6
5 1
23 8
45 4

I want to produce a chart where it show goes to the first column (1) and
then uses the code range(selection, selection.end(xlDown)).select uses the
range that is highlighted as the x axis and then do the same thing for the
second column (5) as Y axis.

This is required as we do not know how many lines of data there will be each
time we create a new chart as we wont the chart to be created by using a
button rather than manually doing it each time.

I hope this makes sense and someone can help.

Thanks
Noemi