The simple way:

1) Hide the rows you don't wish to chart
2) Create a chart.
3) Click Tools, Options, Chart (click on chart first)
4) Uncheck the option to plot visible cells only


"doogie" <doogie@discussions.microsoft.com> wrote in message
news:D382F21C-CDC9-4861-B41B-595BEA39EBAD@microsoft.com...
> How do I keep a line chart from plotting blank cells. Formulas are in
> cells
> that return a blank when false.