OriginLab Corporation - Data Analysis and Graphing Software - 2D graphs, 3D graphs, Contour Plots, Statistical Charts, Data Exploration, Statistics, Curve Fitting, Signal Processing, and Peak Analysis                           
 

2.2.3.46 wheatmap


Menu Information

Worksheet: Conditional Formatting: Heatmap

Brief Information

Apply conditional formatting to worksheet cells using a heatmap

Command Line Usage

1. wheatmap rng:=[Book1]Sheet1!A:B name:="C1R1-C4R0";

2. wheatmap rng:=[Book1]Sheet1!A:B name:="C1R1-C2R0" trcolor.method:=0 trcolor.from:=31306751 trcolor.to:=32497615 trcolor.head:=19 trcolor.tail:=20;

3. wheatmap rng:=[Book1]Sheet1!A:B name:="C1R1-C2R0" trlevel.rescale:=0 trlevel.from:=5 trlevel.to:=30 trlevel.by:=0 trlevel.val:=3 trlevel.first:=6 trcolor.autocolor:=1 trcolor.method:=3 trcolor.name:="Soft Thermometer";

Variables

Display
Name
Variable
Name
I/O
and
Type
Default
Value
Description
Range rng

Input

Range

<active> Specify range of the cells in the worksheet to apply conditional formatting.
Name name

Input

string

Specify the name for the selected range.
Levels trlevel

Input

TreeNode

<unassigned> Set the levels of the heatmap. See more details in this page.
Colors trcolor

Input

TreeNode

<unassigned> Set the colors of the heatmap. See more details in this page.

Description

Use heatmap to color cells according to the level setting.

Related X-Functions

X-Function:wcolor, X-Function:wcolordup


Keywords:cell coloring

 

© OriginLab Corporation. All rights reserved.