remove weekends on graphs

[Rick in Roanoke]

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

 

[Luke M]

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.