Graphing dates with gaps


Posted by yu-kuan on August 31, 2000 1:25 AM

Hi all,

I'm using Excel to graph data on Y axis and dates on X axis. These are trading days so there are no dates or data during the weekends. However, I think, as a built-in function of Excel grapher, it automatically inserts dates into the graph chronologically to fill in the gaps (during weekends, for example) even though the oringinal data ranges do not contain these dates. Since I have a line graph that connects all the Y values, this distorts the shape of the graph. I'd like to know a way where I can keep my X range in date format, and just graph those dates that are in my range, not every single date in the calendar.

Thanks a lot!

Yu-Kuan



Posted by David on August 31, 0100 1:30 AM


Chart options primary axis choose category.
I think this will work.