Minitab

Change the position of tick marks in the axes of a Minitab graph

When you create a graph in Minitab with a lot of data points, Minitab will do its best to locate the tick marks in the axes in a readable way. However, you might want to change the position of tick marks in the axes to better suit your analysis.

For example, let’s say that you take 5 samples for a given variable every 20 days over a period of 520 days. You create a scatterplot as the one in the following image:

As you can see in the previous graph the ticks are located every 100 days. Let’s say you want to locate the ticks every 20 days. One way of doing this would be to double-click on the X-axis and manually type the values 0, 20, 40,… in the box ‘Position of ticks’:

An easier (and faster) way of doing this is to follow these steps:

  1. Double click the X-axis of the scatterplot
  2. In the Scale tab, select Position of ticks
  3. Type 0:520/20 in the box ‘Position of ticks’

This will create the sequence 0, 20, 40, …, 480, 500, 520. See the result below:

In general, a sequence written in the form X:Y/Z will start at X, will continue with increments of size Z until the biggest number less than or equal to Y. See a few examples below:

X:Y/Z Sequence
1:20/21, 3, 5, …, 15, 17, 19
0:20/20, 2, 4, …, 16, 18, 20
1:20*1, 2, 3, …, 18, 19, 20

* Notice that if you don’t include the increment, Minitab will assume 1.

In addition, you can include numbers outside of the sequence.

Examples:

Short waySequence
1 3 5:60/51, 3, 5, 10, 15, …, 50, 55, 60
0:30/5 13 270, 5, 10, 13, 15, 20, 25, 27, 30

Changing the position of tick marks in the axes of Time Series Plots

In time series plots the X-axis is considered as an index value from 1 to the number of observations. However, you can use another variable as a ‘Stamp” for the X-axis.

For example, if you want to plot the column ‘Value’ from the following data set:

You will do the following steps:

  1. Go to Graph -> Time Series Plot -> Simple -> Ok
  2. Double click in the ‘Value’ column to send it to the Series Inputbox and click on ‘Time/Scale’

  1. Select ‘Stamp’ and enter the ID column

In this specific example, the ID column contain values from 100 to 120. The resulting graph for this data set will look as follows:

If you want to locate the tick marks at 100, 105, …, 120 you should not use the sequence 100:120/5. The reason behind this is that time series plots assume an index variable in the X-axis. Therefore, you should use the corresponding index number for the values you want to show.

The following table show the values for the X-axis and the corresponding index values

Value for X-axisIndex
1001
1012
1023
1034
1045
1056
1067
1078
1089
10910
11011
11112
11213
11314
11415
11516
11617
11718
11819
11920
12021

As you can see the corresponding index values are 1, 6, 11, 16, 21; therefore the sequence to use is 1:21/5.

The resulting graph would look like this

Do you know any other tips for tick marks? Please write them in the comments section.

Please go to the top and share this post with people who might benefit.

Newsletter

Stay up to date with our latest news, receive exclusive deals, and more.

© Master Data Analysis All Rights Reserved 2024

Orlando Mezquita

Love helping out people to get better using data analysis tools! My day job is statistician for a Pharmaceutical Company.

Share
Published by
Orlando Mezquita

Recent Posts

18 courses to learn R in 2018

Do you want to learn or get better at R programming?  If yes, you will…

7 years ago

Calculating the median in Excel PivotTables

Go to Master Data Analysis Yes, you read the title of this post correctly, you…

7 years ago

Using R to predict if a customer will buy

In this post, I’ll show how to create a simple model to predict if a…

8 years ago

Data Science for Beginners

Are you wondering what's all this buzz about data science? The following videos will give…

8 years ago

Import excel files with a dynamic starting row

Go to Master Data Analysis This is the 4th post of a series that covers…

8 years ago

Import specific cells from Excel files

Go to Master Data Analysis This is the 5th post of a series that covers…

8 years ago