Depending on the data that sparklines are based on, changing the axes can refine their scale and accuracy and make comparisons easier.
Horizontal axis
|
Option |
Description |
|
General axis |
The default horizontal axis. Each data point is plotted in relation to other data points that make up the sparkline.
|
|
Date axis |
Each data point is plotted in relation to a date. For example, to compare inventory month to month, you would select a range of months as a date axis. |
|
Show axis |
Displays a horizontal axis with the sparkline to better visualize numbers greater than and less than zero. This is especially helpful with line style sparklines.
|
|
Plot data right to left |
Reverses the horizontal axis.
|
Vertical axis
You can set minimum and maximum values for a single sparkline or all sparklines in a group.
|
Option |
Description |
|
Automatic for each sparkline |
Minimum and maximum values are different for each sparkline, and are based on the data that makes up that sparkline. For example, if the data range for a sparkline group is A1:C4, then A1:A4, B1:B4, and C1:C4 each has minimum and maximum values that are based on the highest and lowest numbers in those three ranges. |
|
Same for all sparklines |
Minimum and maximum values are the same for all the sparklines in a group and are based on the lowest and hightest values in the range that makes up that sparkline group. For example, if the data range for the sparkline group is A1:C4, the minimum and maximum values are determined by the lowest and highest numbers in A1:C4. |
|
Custom |
Sets a specific number as the minimum or maximum for the sparkline group. |
