USA/Canada - Online Store | Others - Click Here

How do I use my own labels for tick labels

You can use your own tick labels by entering text into a worksheet column and selecting that column for the tick label values. Note that most of the time you want to use your own labels, you can simply treat them as your categories when plotting data.

1. Enter the text you want to use for tick labels into a worksheet column. Note that if you want to use numbers as text, formatted to a specific decimal place or appearance, use the Format menu Cells command to first set the numeric appearance, then use Format Cells again to convert the number(s) to Text.

2. Open graph properties and go to the Tick Labels panel for that axis. Set the Type of label to be the tick label column.

3. The text or numbers in that column are used for the tick labels.

 
 
bullet
bullet
bullet
bullet
bullet
bullet
bullet
bullet
bullet
bullet
 
bullet
bullet
bullet
bullet
bullet
bullet
bullet
bullet
bullet
 
bullet
bullet
bullet
 
Copyright © 2021 Systat Software Inc., - All Rights Reserved.      e-mail: webmaster1@cranessoftware.com
Terms of Use | Privacy Policy | Sitemap