Data Limits Properties

Data limits properties are used to limit the data appearing in many types of plots in Grapher. Data can be limited on the input side by Worksheet rows, Plot Interval, or Value Limits, and Criteria filtering, and the plot appearance can be limited on the output side by Clipping. Select the plot you wish to limit and click the Data Limits tab in the Property Manager to edit the data limits properties.

 

Change the input data filtering and plot clipping properties in the Property Manager on the Data Limits tab.

 

Data Points Count

The total number of data points used in the plot appears next to the Data points count field. This value changes as the First row, Last row,andFrequency changes. This value is informational and cannot be changed directly.

 

Worksheet Range

Select the data range to plot in the Worksheet range section. The default data range includes the first and last rows/columns in the worksheet that contain data. If Data in rows is selected on the Plot page, the worksheet range is specified by column rather than row.

 

If Auto is selected for the First row and Last row, all of the rows containing data are used. Click the word Custom and select Auto to go back to automatic row selection. The word Auto will appear and the First row or Last row will revert to the default row.

 

To limit the range of the plotted data, you can change the range of rows. Type a new row number into either the First row and Last row boxes. To change the value, either highlight the existing row number and type a new row number or click the to scroll to a new row number. Press ENTER on the keyboard to update the plot. The Auto selection will automatically update to Custom.

 

Use the Frequency to skip rows of data in the plot. For example, if Frequency is set to 5, every fifth data value between the First row and Last row  is plotted on the plot. When Frequency is set to 1, every data value between the First row and Last row is displayed.

 

Stiff Plot Worksheet Rows

The worksheet rows are specified for the left side and right side of a stiff plot independently in the Left rows and Right rows sections.

 

Clipping

The Clipping section sets the limits of the data displayed on the graph. Plots can be clipped to the axis limits or to custom values. When a plot is clipped, the plot is not drawn outside a specific range of values. At least one data point must be within the clipping limits for Grapher to draw the plot.

 

Setting the clipping limits to Axis is useful for quickly viewing a section of the plot by changing the Axis limits. Setting the clipping limits to None always displays the entire plot, regardless of the axis limits. Setting the clipping limits to a custom value can be useful for removing unwanted data from the plot.

 

Clipping Limits

To change the custom clipping value, highlight the existing number in the X minimum, X maximum, Y minimum, Y maximum, Z minimum, Z maximum, Radius minimum, Radius maximum, Angle minimum, and Angle maximum box and type a new value. Press ENTER on the keyboard to accept the new value and update the plot. If the custom value is set to a number that is less than the minimum data value or greater than the maximum value, all of the data is displayed.

 

 Set the X minimum, X maximum, Y minimum, and Y maximum to None, Custom, or Axis. For polar plots, set the Radius minimum, Radius maximum, Angle minimum, and Angle maximum values. 3D plots also contain Z minimum and Z maximum options.

  • Click the word to the right of the value and select None to accept the full data range.

  • Click the word to the right of the value and select Axis to clip the data to the axis limits. If the plot is displaying more data than desired, change the Axis limits on the Axis tab.

  • Click the word to the right of the value and select Custom to limit the plot to a specific range.

 

Values can also be typed directly into the X minimum, X maximum, Y minimum, Y maximum, Z minimum, Z maximum, Radius minimum, Radius maximum, Angle minimum, or Angle maximum boxes. When the value is changed directly, the type of clipping automatically changes to Custom.

 

Custom Date/Time Values

If you have used date/time formatted values to create a graph, date/time tick labels are automatically enabled for that axis. If you select Custom for the X minimum, X maximum, Y minimum, Y maximum,Z minimum, or Z maximum options, you can set the clipping range by dates or time. For example, if date/time data are used for the X values of a plot,  X minimum date/time and X maximum date/time fields are available. Click the current date/time value next to X minimum date/time and X maximum date/time to open the Select Date/Time dialog. Set a new date and time and click OK to return to the Property Manager. Alternatively, highlight the date/time value next to X minimum date/time or X maximum date/time and type the desired date or time value. Press ENTER on the keyboard to update the plot. When inputting date/time values directly in the Property Manager, date/times must always be entered as MM/dd/yyyy hh:mm:ss. No other formats are permitted in the date/time edit boxes in the Property Manager.

 

Draw Plot to Clipping Limit

When a plot is clipped, the lines in the plot are drawn connecting the visible data. When the Draw plot to clipping limit box is checked, the shape of the line reflects data outside the clipping limits and the line is drawn to the extents of the clipping limits. For example, if you clip a line/scatter plot to a minimum of 100 and a maximum of 300, but the data appear at a minimum of 125 and a maximum of 255 within these limits, the line is limited to 125 to 255. Check the Draw plot to clipping limit box to draw a line to the extents of the clipping limits, in this case, 100 to 300.

 

The original plot is shown without clipping.

The X axis clipping is set to a range of 100 to 300. The X axis range is 0 to 400. The Draw plot to clipping limits option is not checked. The line is drawn between the visible, unclipped points, as if the clipped points did not exist in the data table.

The X axis clipping is set to a range of 100 to 300. The X axis range is 0 to 400. The Draw plot to clipping limits option is checked. The line extends to 100 and 300. The shape of the line changes to reflect outlying clipped points.

 

For a bar chart, if the Draw plot to clipping limit is checked, the bar is displayed extending to the clipping value. If the box next to Draw plot to clipping limit is not checked, the bar is removed from the plot.

 

This bar chart displays all of the bars without any clipping. The label displays the X value being plotted in all these bar charts.

This bar chart is clipped to a maximum X value of 49. The Draw plot to clipping limitis not checked, so the clipped bars are completely removed.

This bar chart is clipped to a maximum X value of 49. The Draw plot to clipping limitis checked, so the clipped bars are displayed to the clipping value.

 

Clip Plot to Polar Circle

For polar plots, when the Clip to polar circle box is checked, points outside the Angle axis are not drawn. These points are completely removed from the polar plot. When theClip to polar circlecommand is not checked, the plot can extend beyond the Angle axis.

 

This plot has points outside the Angle axis and no clipping

This plot has theClip to polar circle option checked. The points outside the Angle axis are removed. In this example the Missing data property is Continuous plot, so the lines are redrawn connecting the remaining points.

 

Data Criteria

The Criteria setting allows you to specify filtering criteria for excluding data from a plot. Data can be excluded by specifying values to ignore, NULL criteria, or only certain data can be included by specifying to use only data that matches specified value(s) in a column, Column criteria. Click the Setbutton next to Criteria to open the Criteria dialog where you can specify the custom criteria. After specifying the criteria in the Criteria dialog, the Criteria property is updated to display the criteria filter type.

 

Fit Plot Interval

The Plot interval section controls the limits of the fit curve. The Plot interval can extend the fit curve beyond the data limits of the original plot. Click the next to the Plot interval option to open the section. The Plot interval section only controls the values where the fit curve is displayed. The Plot interval does not change which data is fitted. To create the fit curve from only a subset of the plot data, use the Fitted plot properties on the fit curve Plot page.

 

Plot Limits

ThePlot limitsoption sets how the limits for the fit curve are chosen. The Fitted data limits option uses the Minimum value and Maximum value from the Plot page Fitted plot section for the Minimum plot value to fit and Maximum plot value to fit values. The Axis limits option extends the fit plot to the entire axis range. When the axis limits are changed, the fit curve is automatically changed to fit the new axis limits. TheCustom option allows custom values to be set for the First X and Last X values. To change the Plot limits, click on the current option. Select the new option from the list and the plot will automatically update.

 

If the custom fit range is greater than the axis limits and the axis is set to use automatic limits, the axis range changes to match the customized limits. If the axis limits are set to custom limits, the fit curve can exceed the axis area if the First X or Last X value is outside the axis range.

 

To change the First X or Last X values, highlight the existing value and type a new value. Press ENTER on the keyboard to make the change.

 

The running average, weighted average, and spline smoothing fits do not extrapolate the fit beyond the data. Regardless of the values in the Plot interval section, the fit curve will not plot beyond the original plot's X range.

 

Function Value Limits

Specify the function interval, or range of the variable, in the Value Limits section. The First value and Last value properties specify the beginning and end of the function plot. To change the value, highlight the existing value and type the new value. Press ENTER on the keyboard to make the change. Enter the first value for the independent variable into the First value box. Enter the last value for the independent variable into the Last value box.

 

Number of Points and Increment

The Number of points determines how many times the equation is calculated. This determines the number of plotted data points. A larger number of points means more detail is plotted in the function. However, the larger the number of points, the longer it will take to graph the function. When the Number of points is changed, the Increment value is automatically updated. The Increment value shows the difference in the independent variable (X, Y, A, or T depending on function Type) values between adjacent points on the graph. When the Increment value is changed, the Number of points is automatically updated. The Number of points cannot exceed 1000.

 

Grid Rows

Select the number next to First row to change the number of the first row to be used in the map. This value cannot exceed the number of rows in the grid file. Select the number next to Last row to change the number of the last row to be used in the map. This value cannot exceed the number of rows in the grid file.

 

If Auto is selected for the First row and Last row, all of the rows containing data are used. To limit the range of the plotted data, you can change the range of rows. Next to First row or Last row, click the word Auto and select Custom. You can then enter a new row number into either the First row and Last row boxes. To change the value, either highlight the existing row number and type a new row number or click the to scroll to a new row number. Press ENTER on the keyboard to update the plot.

 

Click the word Custom and select Auto to go back to automatic row selection. The word Auto will appear and the First row or Last row will revert to the default row.

 

Select the number next to First column to change the number of the first column to be used in the map. This value cannot exceed the number of columns used in the grid file. Select the number next to Last column to change the number of the last column to be used in the map. This value cannot exceed the number of columns used in the grid file.

 

If Auto is selected for the First column and Last column, all of the columns containing data are used. To limit the range of the plotted data, you can change the range of columns. Next to First column or Last column, click the word Auto.  It will change to Custom. You can then enter a new column number into either the First column and Last column boxes. To change the value, either highlight the existing column number and type a new column number or click the to scroll to a new column number. Press ENTER on the keyboard to update the plot.

 

Click the word Custom to go back to automatic column selection. The word Auto will appear and the First column or Last column will revert to the default column.

 

 

See Also

Standard Axes

Angle Axes

Tick Marks