Hi, lets say i have a cell A1 that shows the text B1:B5, and i have a cell A2
that shows the text C1:C5. Then i want to have a chart that references cells
A1 and A2, and hence knows that i want it to chart the data in arrage B1 to
C5 (an x-y scatter plot). the point being the text values in cells A1 and A2
might change, and i want to the chart to automatically update and plot the
new ranges specified. i can't work out how to do this. is it possible?

thanks