Changing the X Axis Date/Time Limits - Tutorial

The axis limits can use the default limits or can be changed to show only a portion of the graph. Limits can be based on numerical values or on date/time values. To change the X Axis limits using date/time values:

  1. Click X Axis 1 in the Object Manager to select it.

  2. In the Property Manager, click on the Axis tab to display the axis properties.

  3. Click the  to the left of the Limits section to expand the axis limits.

  4. Click the next to the 12/18/2008 0:00:00 value next to Minimum date/time to open the Select Date/Time dialog.

  5. Change the date to 1/1/2009 and click OK.

  6. Dates can also be edited directly in the Property Manager. Highlight the 3/28/2009 value next to Maximum date/time and type 4/1/2009 and press ENTER.


The X Axis limits now range from 1/1/2009 to 4/1/2009. Date/time values can be displayed in any format on axis and plot labels and in the worksheet. However, M/d/yyyy h:mm:ss format must be used when entering date/time values in the Property Manager.


The axis updates to the new date/time limits.



Back to Creating a Line/Scatter Plot

Next to Changing the X Axis Date/Time Tick Mark Spacing