View Single Post
  #2   Report Post  
Steve
 
Posts: n/a
Default

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.