Statistics add-in software for statistical analysis in Excel
  • User's Guide
  • Preparing data for analysis

Setting the minimum, maximum and units of a variable

Set the minimum/maximum and units so that the axes of charts are scaled to your preferences.

Note: If you do not set a scale then the chart axis scale will be determined automatically by the data values. If you do specify the scale, but the data values are outside the minimum/maximum then axes are scaled to the next unit. If the unit is too small to show with a label on the axis it is shown as a minor tick mark.
Note: If you have the analysis task pane open you can quickly change the scaling for a variable: right-click over the variable, or click the drop-down menu button alongside the variable selector, and then click Scale.
  1. Activate the dataset worksheet.
  2. On the Analyse-it ribbon tab, in the Dataset group, click Dataset.
    The dataset task pane opens.
  3. In the Variable list, select the variables:
    • To select a single variable, click the variable.
    • To select multiple variables, click the first variable then hold down the CTRL key and click each additional variable.
    • To select a range of variables, click the first variable then hold down the SHIFT key and click the last variable in the range.

    The cells of the selected variables highlight on the worksheet. You can also select cells on the worksheet to select the corresponding variables in the list.

  4. If the measurement scale is not already set, click Interval, Ratio, or Absolute.
  5. In the MinimumMaximum and Units edit boxes, optionally, type the value for each. You can provide a minimum value only, a maximum value only, or a minimum, maximum and units. If you provide units then the range (the maximum - minimum) must be a factor of the units (the range must be divisible by the units).
  6. Click OK.

    Any future or updated analysis will now use the preferred scale where possible.

  •  What is Analyse-it?
  •  What's new?
  •  Administrator's Guide
  •  User's Guide
  •  Getting to know Analyse-it
  •  Preparing data for analysis
  •  Datasets
  •  Variables
  •  Measurement scales
  •  Missing values
  •  Case and frequency form data
  •  Setting the measurement scale of a variable
  •  Setting the minimum, maximum and units of a variable
  •  Ordering categorical data
  •  Setting the number format of a variable
  •  Labeling cases
  •  Assigning labels to categories
  •  Assigning colors/symbols to categories
  •  Transforming variables
  •  Transform functions
  •  Analyzing a subset of the data
  •  Working with analyses
  •  Feedback and crash reports
  •  Statistical Reference Guide



Version 6.15
Published 18-Apr-2023
statistics software, statistical software for Excel
  • Products
  • Store 
  • Support
  • Blog
  • About us
  • Download trial
  •  Search
  •  Sign in
  •  Contact us
Analyse-it editions
  • Standard edition
  • Medical edition
  • Method Validation edition
  • Quality Control & Improvement edition
  • Ultimate edition

  • Blog  
  • About us
  • Contact us  
  • Privacy policy


Copyright 2026 Analyse-it Software, Ltd, Leeds, United Kingdom .
We use essential cookies to run the site, and optional analytics to improve the experience for visitors. For more information see our Privacy policy.