Hello all,

I have a chart that is based on dates and I want to be able to skip dates
that do not have any data associated with it.

Example:

A B
1/1/05 1
1/2/05 2
1/3/05 1
1/6/05 3
1/7/05 2

Currently, my X axis has the dates 1-31 and if there is a gap in dates, it
plots the missing dates as zero. I want the chart to not not put the missing
dates from the range on the axis. In other words, just have 1, 2, 3, 6, 7,
etc on the X axis.

How do I do that? I have already tried changing the Chart options from
Automatic to Time-Scale .

Thanks for any help,

Sharon
Sharon