How can I chart a data series without showing empty cells?

[Brent]

I have several data series with values for each day of the week. Some weeks
there will be a value for Saturday in some of the data series, while other
Saturday cells will remain empty. How can I chart these series and not show
gaps for the empty cells?

 

[Bernard Liengme]

If it is a Line chart, try:
Replace the empty cell with =NA()
or
With chart select, use Options|Chart and specify what you want for "plot
empty cells"

For Column chart: use Chart Option (right click chart to open a menu), on
Axis tab set to Category rather than Auto or Time Series

best wishes--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email