Ok Del, many thanks for your reply. I will collate the info onto one page
and chart from that. Perhaps I was trying to be too clever.

Regards

Roger
"Del Cotter" wrote in message
...
On Sun, 24 Jun 2007, in microsoft.public.excel.charting,
roger lewis said:
I am trying to produce a simple line graph from values in worksheets
within
a workbook.
I thought that you could hold the ctrl key down and select the data from
each cell in the worksheet but I have obviously got that wrong.

Don't try to take values straight out of the workbooks and straight into
a chart. You're only making life unnecessarily hard for yourself. Take
values from the workbooks and put them into a range in one summary
workbook and build the chart there.

A B
01/01/07 £5 £2
01/02/07 £4 £2.50

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.