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

Assigning colors/symbols to categories

Assign colors or symbols to highlight observations on plots.

  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 Variables list, select the variable.
  4. If the measurement scale is not set, click Nominal or Ordinal.
    The Categories grid shows the codings used in the data.
  5. Select the Assign colors/symbols check box.
    The Categories grid shows the Symbol and Color columns.
  6. Optional: Click a cell in the Color column and select a preset color.
  7. Optional: Click a cell in the Symbol column and select a symbol.
  8. Repeat steps 6 through 7 for each coding.
    Note: Any categories without an assigned symbol use a square, and any without an assigned color use black. You can assign symbols and colors just to the categories you want to highlight. The others use the default symbol and color.
  9. Click Apply.
    The changes are saved and will be used in future analyses.

  •  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.