The Multi-Colored tab of the Format Data Series dialog is used to color data series in a user defined color gradient based upon the bars relative range, specific upper/lower ranges, relative increase/decrease, or actual increase/decrease.
To set upper and lower range colors:
- Select the Upper / Lower Range colors option to enable coloring based upon either a relative range or specific upper/lower range.
- Change the upper range color by clicking the small down arrow on the Upper Range Color drop down and click on the desired color. An indented box notates the current upper range color of the selected data series.
- Change the lower range color by clicking the small down arrow on the Lower Range Color drop down and click on the desired color. An indented box notates the current upper range color of the selected data series.
To set gradient coloring of the data series based upon its relative range:
- Select the Gradient coloring relative to last ___ bars option and enter the desired number of bars for the relative range gradient coloring.
The gradient color shading is determined based upon the number of last bars chosen. So for instance if you choose 14 bars, the current bar’s color will be chosen based upon its value relative to the min and max values over the last 14 bars. If it is at an extreme max or min, then it will be colored in the Upper Range Color or Lower Range Color, otherwise it will be colored in a color shade between the two colors in proportion to its distance from the maximum and minimum value over the last 14 days.
To set the color of the data series when its values are in a specific upper or lower range:
- Unselect the Gradient coloring relative to last X bars option to enable entry of upper and lower values. Enter the desired upper range value in the Values >= text box and desired lower range value in the Values <= text box.
The data series will be colored in the Upper Range Color whenever the data series value is above the Values >= value. Likewise, the data series will be colored in the Lower Range Color whenever the data series value is below the Values >= value. When the data series value is between the upper and lower range values, the data series will be colored in the default color or the increasing/decreasing colors if that option is selected.
To set increasing and decreasing colors:
- Select the Increasing / Decreasing colors option to enable coloring based upon either a relative increase/decrease or the actual increase/decrease.
- Change the increasing color by clicking the small down arrow on the Increase Color drop down and click on the desired color. An indented box notates the current increasing color of the selected data series.
- Change the decreasing color by clicking the small down arrow on the Decreasing Color drop down and click on the desired color. An indented box notates the current decreasing color of the selected data series.
To set gradient coloring of the data series based upon its relative increase or decrease:
- Select the Gradient coloring relative to last ___ bars option and enter the desired number of bars for the relative increase/decrease gradient coloring.
The gradient color shading is determined based upon the number of last bars chosen. So for instance if you choose 14 bars, the current bar’s color will be chosen based upon its current increase/decrease relative to the min and max increase/decrease over the last 14 bars. If it is at an extreme increase or decrease relative to the last 14 days, then it will be colored in the Increasing Color or Decreasing Color, otherwise it will be colored in a color shade between the two colors in proportion to the distance of its increase/decrease from the maximum increase and minimum decrease over the last 14 days.
To set a solid color for the data series when its values are increasing or decreasing:
- Unselect the Gradient coloring relative to last X bars option to enable solid coloring of increasing and decreasing colors.
The data series will be colored in the Increasing Color whenever the data series is increasing. Likewise, the data series will be colored in the Decreasing Color whenever the data series value is decreasing. When the data series value does not change, the data series will be colored in the default color.
When you are satisfied with the Format Data Series settings, select the OK button.
Note:
- The increase/decrease for each bar is measured as the 1 bar change in the data series, except when the data series has both an Open and Close, in which case the increase/decrease is measured as the difference between the Closing and Opening values.
- The upper/lower and increase/decrease coloring does not work with area charts. Area charts will be displayed as bar charts when upper/lower and increase/decrease coloring is being utilized.