It would be ugly to try to extract alternating points directly from a long
list, but you could use formulas to get every Nth point into a particular
column (e.g., points 1,6,11,16, etc into column D and 2,7,12,17, etc into
column F; alternatively 1-20, 61-80 in column D and 21-40, 81-100 in column
F).

I didn't mean my little rant as a criticism of your approach. I understand
that it's important to have sizable data sets. Just the more trees you have,
the harder it may be to focus on the forest.

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


"NormD" wrote in message
...
OK, you got me with this one! I understand interleave, but have never done
that in Excel. I gather there is a way to define a series with, say, with
every other point? They there would be two series, for example. I don't
know what selecting the range would be like and how Excel would handle
that,
would it still complain about the total range, not recognizing the
includsion
of every Nth point.

Re doing the trend line in the spreadsheet and plotting the line, my
response is "Duh!" Of course! You're absolutely right. Guess I'm too
close
to the problem!

"Del Cotter" wrote:

On Wed, 7 Feb 2007, in microsoft.public.excel.charting,
NormD said:
I've not tried it, but perhaps several 32K series can follow one another
so
at least the graph looks continuous. However, if one is trending that
presents a problem between series.

You could do the trending in the spreadsheet and then plot it in the
graph.

It occurred to me that intead of following one another in two continuous
ranges, you might arrange to have them interleave, say one series
showing the even hours and one showing the odd ones. The you could have
them be subtly different shades to show up the hours, and do away with
the need for vertical gridlines.

--
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.