Time series plot; how to omit empty dates

[jonnyyyl]

Suppose I have a historical data of my sales figures. When I plot a line graph in excel, how do I omit days without sales (ie public holidays and weekends)?

Thanks.

[Andy Pope]

Format axis as text rather than date. The each date will appear as a category item