Hello all. This is my first post here. I found this forum while trying to Google this problem. It looks to be a very active forum!
I am collecting a single data point each work day. Therefore, I have dates in the A column that go, for example, cell A1 has Monday, Jan 4, cell A2 has Tuesday, Jan 5......cell A5 has Friday, Jan 8. Then since I only collect this data during week days, the next cell, A6 has Monday, Jan 11, cell A7 has Tuesday, Jan 12...and so on. Just a straight list on weekdays with a corresponding single number in column B.
The problem occurs when I try to chart this info. Excel adds the "missing" Saturdays and Sundays to the X-axis labels even though they are not in the column A data.
I have tried several formats but it does not do any good. I have also tried to adjust the axis scale but it seems to automatically assume a 7 day week even when I only have 5 days per week listed. I have also tried searching this forum for this question but did not find an answer within the first few pages of the search.
I am running Excel 2003.
Any help would be appreciated.
Thanks,
Numcruncher1
Bookmarks