software

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?
--
Brent

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 quot;plot
empty cellsquot;

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

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