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.