You might get some ideas from
http://www.peltiertech.com/Excel/Cha...AreaChart.html

It is not clear from your post wether this behavior is desirable or
undesirable.

Jerry

Bill H. wrote:

I have a line chart in one spreadsheet that contains values that are
linked (within the same spreadsheet) from two other spreadsheets.



What I can't figure out is why the first set of values (one year of
data) displays as a normal line chart, but the second set of values
(another year from the other spreadsheet) is all filled in.