Sorry, I must not have explained this well enough. I don't want every
18th value to be charted on the graph, what I want is once the index
reaches 18, say on March 3, then there should be a vertical line on the
graph. If the index reaches 36 on March 5 then there should be another
vertical line, and so on.

I've included a sample of a chart to give you a better idea.

Thanks again,

Matt


+-------------------------------------------------------------------+
|Filename: Chart.pdf |
|Download: http://www.excelforum.com/attachment.php?postid=4417 |
+-------------------------------------------------------------------+

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

As I wrote the answer, I wondered if that was what was needed.
Change <In C2:C120 I have =IF(MOD(ROW()-1,18),NA(),B2)
To =IF(MOD(B2,18), NA(), B2) in C2 and copy down the column
And proceed as I indicated
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"matthoffman33"
wrote in message
news:matthoffman33.2469uy_1141521302.4499@excelfor um-nospam.com...

Sorry, I must not have explained this well enough. I don't want every
18th value to be charted on the graph, what I want is once the index
reaches 18, say on March 3, then there should be a vertical line on the
graph. If the index reaches 36 on March 5 then there should be another
vertical line, and so on.

I've included a sample of a chart to give you a better idea.

Thanks again,

Matt


+-------------------------------------------------------------------+
|Filename: Chart.pdf |
|Download: http://www.excelforum.com/attachment.php?postid=4417 |
+-------------------------------------------------------------------+

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

Hi,

OK, that works just great but only if the index value lands on 18, 36,
54, ets. I also need a line to be drawn if that value is passed. For
example, if the index goes from 17 one day up to 19 the next day. I
would need a vertical line to be displayed either on the day for the 19
or approximately half way in between the 17 and the 19. Is this
something that is just simpler to do manually?

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