Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Automatically adding Vertical lines after certain points in line graph
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Automatically adding Vertical lines after certain points in line graph
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Automatically adding Vertical lines after certain points in line graph
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Automatically adding Vertical lines after certain points in line graph
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 |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Automatically adding Vertical lines after certain points in line graph
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to find intersections points of lines in charts | Charts and Charting in Excel | |||
Possible to Add Horizontal Line to Embedded Graph via VBA? | Charts and Charting in Excel | |||
Moveable Vertical Line | Charts and Charting in Excel | |||
How to force continuous lines in line charts | Charts and Charting in Excel | |||
create space in line chart between points, linked to pivot table | Charts and Charting in Excel |