Archive of Mr Excel Message Board

Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007

Back to Charting for Excel archive index
Back to archive home

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.

Re: Charting Dates in Excel

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.

Re: Charting Dates in Excel

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.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.