Hi all,
I have a requirement to show time in MM:SS format in Y axis of a graph.I have used 'HIS' format to show time in MM:SS . Suggest me how can this be done. Please find the code and the sample graph


DEFINE FILE CAR
XX/HIS=HGETC(8,'HIS');
END

GRAPH FILE CAR
PRINT XX
ACROSS CAR
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB ON
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHSTYLE *
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
ENDSTYLE
ON GRAPH SET STYLE *
$
ENDSTYLE
END

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

I don't like your chances.

The graph engine goes part the way there, but I would suggest asking Techsupport about formatting times in the graph.

After you get the time with HIS could you not then use EDIT to remove the hour section?

Thanks Waz..

Hi Mary, The problem is not with the hour part , 'HIS' works fine in a tabular report. The problem when that is placed in the graph Y axis. Graph takes its own format instead of the desired mm:ss format.

Sivashankari,

Have you looked in the documentation for graphs at the API calls?

Example: setY1LabelFormatPattern("#.#$");

-Mary

Hi Mary,

I did check the documentation. There is no format for mm:ss.

Thanks
Shankari

quote:

setY1LabelFormatPattern("#.#$");

I have not tried this, but did you try the following:

 
setY1LabelFormatPattern("##:##");

or 

setY1LabelFormatPattern("0#:##");

This message has been edited. Last edited by: Mary Watermann,