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

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 "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

"Brent" <Brent@discussions.microsoft.com> wrote in message
news:397DB34A-692B-4035-9262-15D528ED2A48@microsoft.com...
>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