remove weekends on graphs

  • Thread starter Thread starter Rick in Roanoke
  • Start date Start date
R

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
 
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.
 
Back
Top