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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Eliminate weekends on chart 1
removal weekend - chart 2007 1
Graph Autorange 2
Graph linked with combo boxes 2
Show only workdays in chart axis? 4
update graphs automatically either from same book or a new spreads 1
Graph with a mind of its own 2
Remove the weekends from a pivot chart x axis 0

Back
Top