I have labels ("Date" and "Index") in A1 and B1
In A2:A120 I have a date series
In B2:B120 I have index values
In C2:C120 I have =IF(MOD(ROW()-1,18),NA(),B2)
So if the y-value is the 18th, 36th, ... (rows 19, 37...) I see a value,
otherwise I see #N/A which Excel ignores when plotting
Next I formatted the data series on the chart, on the Y-error Bars tab I
specified Custom errors-bars; left positive empty and in =negative box enter
C2:C120
This gives me drop down lines.
hope this helps
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"matthoffman33"
wrote in message
news:matthoffman33.245p9b_1141494601.9543@excelfor um-nospam.com...

Hi,

I'll get right to the point. For my X series I have 7 consecutive
dates. For my Y series I have different values representing a disease
index. An example for the Y series would be 5, 12, 23, 27, 35, 42, 58.
I need to some how have a vertical line drawn after every 18th index,
so at 18, 36, 54, 72, etc. It doesn't necessarily need to be drawn at
that exact value, it could be drawn every time that value is reached.
Does this make sense??? Any help would be appreciated.

Thanks,

Matt


--
matthoffman33
------------------------------------------------------------------------
matthoffman33's Profile:
http://www.excelforum.com/member.php...o&userid=32148
View this thread: http://www.excelforum.com/showthread...hreadid=519008