remove weekends on graphs
 

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

remove weekends on graphs
 

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