Since it sounds like you are taking data linearly, under Chart Options, axis,
change the x-axis to category. Now it will only display labels for the dates
you actually have.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Rick in Roanoke" wrote:

I have an excel graph with data that spans several weeks. The data is a
point correlated to a date. The data points are collected only during the
week; there is not weekend data. The graph includes the weekend dates that
have not data which takes up space on my chart. How can I get the graph to
leave the weekend dates out? My data sheet does not have the weekend dates.
Thanks