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