Focal Point
[CASE-OPENED] Define color for column in chart

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9767087606

July 12, 2011, 02:56 PM
Carlos Dias
[CASE-OPENED] Define color for column in chart
Depending of a parameter I want to show or hide a column in my chart.
The problem is that I can not set the color for each column (max is red, avg blue and min green). I only can define it for the series.

It seems a simple issue but I can't find the solution. I already try the conditional formating solution.

My code:
  
...
-IF (&selmax.EXISTS) THEN GOTO MAX_SELECTED ELSE MAX_UNSELECTED;
-MAX_SELECTED
-SET &printmax='';
-GOTO MAX_SELECTED_FINAL
-MAX_UNSELECTED
-SET &printmax='NOPRINT';
-MAX_SELECTED_FINAL
...

GRAPH FILE &filename
SUM MAX.&metric &printmax AS 'Max'
AVE.&metric &printavg AS 'Avg'
MIN.&metric &printmin AS 'Min'
BY &colname AS &labelname
...
ON GRAPH SET LOOKGRAPH VBAR
...
ON GRAPH SET GRAPHSTYLE *
-* Series color
setFillColor(getSeries(0),new Color(198,23,58));
setFillColor(getSeries(1),new Color(75,132,185));
setFillColor(getSeries(2),new Color(81,148,60));
ENDSTYLE



Thanks in advanced,
Carlos Dias

This message has been edited. Last edited by: Kerry,


WebFOCUS version: 7.6
Linux/Windows
HTML, Excel
July 20, 2011, 10:47 AM
Kerry
FYI, it looks like Carlos already has a case opened regarding this issue, and the case is currently in research mode.

Carlos, when you hear an update/solution from the case, can you please post here? Thank you in advance for sharing with all.

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.