I have a Line graph that reports 30 days worth of data...and each day the amounts change. I have been asked to add a 3rd amount...that only updates once a month...and then stays consistant thoughout the month. They would like this line..to only spike up one day for the month. As it is now there is a line all the way across the graph...for each day. any thoughts on how to make this work. Example below:


APP PATH IBINCCEN

DEFINE FILE CENTORD
TODAY/MDYY = '&DATEMDYY';
CONTRACT_VOL_BPD/P18.2 = 2500000;
END
GRAPH FILE CENTORD
SUM LINEPRICE
LINE_COGS
LST.CONTRACT_VOL_BPD
ACROSS ORDER_DATE AS ' '
IF ORDER_DATE LT '2001/02/28'
ON GRAPH SET LOOKGRAPH VLINE
ON TABLE SET PAGE NOLEAD
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET VAXIS 550
ON GRAPH SET HAXIS 1100
ON GRAPH SET GRAPHSTYLE *
setLineWidth(getSeries(0), -1);
setLineWidth(getSeries(1), -1);
setMarkerShape(getSeries(1), 11);
setMarkerShape(getSeries(0), 13);
setMarkerShape(getSeries(2), 2);
setMarkerSizeDefault(35);
setTextRotation(getO1Label(),3);
setMarkerDisplay(true);
setConnectLineMarkers(true);
setConnectScatterMarkers(true);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setSeriesType(0,2);
setAxisAssignment(1,0);
setSeriesType(1,2);
setSeriesType(3,2);
setY1LabelDisplay(true);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(true);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setToolTipDisplay(true);
setToolTipDelay(100);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setLegendTextAutofit(true);
setO1LabelAutofit(true);
setPlace(false);
setFontSizeAbsolute(getO1Label(),true);
setFontSize(getO1Label(),12);
setFillColor(getDataText(),new Color(206,0,54));
ENDSTYLE
ON GRAPH SET STYLE *
PAGESIZE='Letter',
LEFTMARGIN=0.000000,
ORIENTATION=LANDSCAPE,$

TYPE=REPORT,
COLOR=RGB(255 242 191),
GRID=OFF,FONT='TIMES NEW ROMAN',SIZE=10,STYLE=NORMAL,$
TYPE=DATA,
ACROSSCOLUMN=N1,
COLOR='BLUE',
$
TYPE=DATA,
ACROSSCOLUMN=N2,
COLOR=RGB(51 153 102),
$
TYPE=DATA,
ACROSSCOLUMN=N3,
COLOR='RED',
$
TYPE=DATA,
ACROSSCOLUMN=N4,
COLOR='RED',
$
TYPE=FOOTING,LINE=1,OBJECT=TEXT,ITEM=1,SIZE=9,FONT='TIMES NEW ROMAN',COLOR='BLACK',STYLE=ITALIC,BACKCOLOR=RGB(210 210 210),$
TYPE=FOOTING,LINE=2,OBJECT=TEXT,SIZE=9,FONT='TIMES NEW ROMAN',COLOR='BLACK',STYLE=ITALIC,BACKCOLOR=RGB(210 210 210),$
TYPE=FOOTING,LINE=3,OBJECT=TEXT,SIZE=9,FONT='TIMES NEW ROMAN',COLOR='BLACK',STYLE=ITALIC,BACKCOLOR=RGB(210 210 210),$
ENDSTYLE
END

Prarie,

To get the data not to show it needs to be a null values and not zero. You will then have to use a combination of VZERO = ON|OFF and PFJ line settings.

Good luck

T

Thanks...

VMIN and VMAX set the Y axis top and bottom points. I.E.

GRAPH FILE CAR
SUM SALES
ACROSS MODEL
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET AUTOTICK OFF
ON GRAPH SET VAUTO OFF
ON GRAPH SET VMAX 25000
ON GRAPH SET VMIN 100
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHSTYLE *
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
PAGESIZE='Letter',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
BACKCOLOR='NONE',
STYLE=NORMAL,
$
ENDSTYLE
END