MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Graphing non-contiguous dates contiguously ?


Posted by CAL on October 09, 2001 11:58 AM

This seems like a simple problem, but I don't find a simple answer. I have a series of dates that exclude weekends, holidays, and other occasional lapses. When I chart it, there is a blank area for the missing dates. I simply want to compress the chart, e.g. have Monday be continuous from teh previous Friday.

Thanks in advance for any help you can give.


Posted by Eric on October 09, 2001 1:12 PM

An idea

It sounds like you are plotting the data as an X-Y graph with the dates as X values. If the distance between the dates isn't important, then plot just the data as a bar (or line) graph, on step two of the chart wizard, under the series tab, make the "date" column the "x axis labels". Then click "finish", double click on the X axis, and under the "scale" tab set "major unit" to 1. Is that what you are looking for?

note that you could play with the values in the "date" column if the date reports are too crowded.
=IF(ISODD(ROW()),A1,"")
and copy down beside your date column would give you every other date for plotting along the x axis, just right click the graph, source data|Category X axis labels and input the new column

HTH

Posted by CAL on October 11, 2001 11:35 AM

Re: An idea

Thanks, Eric. Yes, I have the dates as the X-axis, but the data is market data (OHLC bars). I need each date as a discreet value. The X-axis labels are the dates - it doesn't matter how often the labels are (e.g. 10,14, etc. days). But, I want the vertical bars to be adjacent without the weekend skip. Does this clarify my problem any?


Posted by Eric on October 11, 2001 2:59 PM

Could you email me a sample workbook or post part of the problem here? (NT)


Posted by CAL on October 11, 2001 3:58 PM

Re: Could you email me a sample workbook or post part of the problem here? (NT)

It is in the mail. Thanks.