Charting Dates in Excel

Posted by Jennifer Martin on June 18, 2001 9:44 AM

I was wondering if anyone knows how to remove certain dates from a chart. I have data that is continuous, but there is normally no data for the weekends. I would like to remove the weekend dates from the chart, so that only the days with information are included. These dates still show up even when they are not included in the spreadsheet information.

Posted by Mark W. on June 18, 2001 10:06 AM

Use a text representation of your weekday dates as
the category (X-axis) values. For example,
=TEXT(A2,"mm/dd") will convert date values to
"mm/dd" text values. Make sure that you keep these
text values in date order.

Posted by Curtis Ng on June 20, 2001 3:30 PM

Under Chart Options, choose Category in the Axes tab. This should display data only.