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