Nanoking,
One option is to reference your X-axis series with a formula that converts
the date to text but still leaves the "text" date looking like a date. For
example, assuming the data below starts in cell A1, convert column A to text
by using this formula:
=TEXT(A2,"mm/dd/yy")
col A col B col C
Orig. Date Text Date Data
01/01/04 01/01/04 5
01/02/04 01/02/04 4
01/03/04 01/03/04 5
In the formula view, column B looks like
=TEXT(A2,"mm/dd/yy")
=TEXT(A3,"mm/dd/yy")
=TEXT(A4,"mm/dd/yy")
Change your X-axis reference from column A to column B. The chart will read
the X-axis dates as text and will not leave gaps.
----
Regards,
John Mansfield
http://www.pdbook.com
"nanoking" wrote:
My data uses only week day dates. The chart that results from it is adding
weekend dates even though they don't appear in the range for the X axis. It
leaves gaps in the chart as a result.