This is an example where spending five minutes with the data will save hours
struggling with the component (in this case the chart) that uses the data.
You could spend five minutes setting up another range where a single
continuous column of cells links to the various cells spread out on the
table that is apparently formatted to give a nice display. Such a single
column would make a chart so easily.

Given that five minutes is too long to spend to make the data right, you
could make the chart from the first continuous set of cells, then copy more
cells, select the chart, use Paste Special from the Edit menu, and paste the
cells as new points (not new series). This might tack the points onto your
series in the manner you'd like them to.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"sadman49" wrote in message
...
Hi All
I've got a Excel file with 12 speadsheets, one for each month. Lets just
deal with January, the cells i'm dealing with are E6,
F6,G6,J6,K6,L6,M6,N6,G12,H12, I12,J12,K12,N12,E18,F18,G18,H18,K18,L18.
I'm trying to make a line chart but because i just want to use these cells
when i try to enter the data range it just uses the K18 and L18, i know
its
gonna be so darn simple or impossible lol
Hope you wiz people can help.
John