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" wrote in message
...
How do I keep a line chart from plotting blank cells. Formulas are in
cells
that return a blank when false.
|