If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
is there any built in function to draw lines
Having given two dates is there any way to plot line from these two dates. (
say dates in continuous cells) Regards, Krish |
#2
|
|||
|
|||
is there any built in function to draw lines
Hi Krishnan
No built in functions to draw lines..If you are looking to link the formulas check out the 'Trace Precedents' option. In 2003: Menu ToolsFormula Auditing and in 2007: Menu FormulasFormula Auditing Trace Precedents will show arrows to cells which are referenced in the formula Trace Dependents will show arrows to cells which are affected by the selected cell If this post helps click Yes --------------- Jacob Skaria "krishnan" wrote: Having given two dates is there any way to plot line from these two dates. ( say dates in continuous cells) Regards, Krish |
#3
|
|||
|
|||
is there any built in function to draw lines
You can DRAW lines using the drawing toolbar like in Paint
View - Toolbars - Drawing. Dates are really numbers so you can use the autofill features in excel to continue a sequencye of numbers. so if you extended a sequence of numbers like 1, 3, 5, 7, ... you can use the same method with dates. Each DAY is equal to 1. So if you started a sequence 1-Jan-09 1-Feb-09 you would get 1-Jan-09 1-Feb-09 1-Mar-09 1-Apr-09 1-May-09 1-Jun-09 1-Jul-09 1-Aug-09 1-Sep-09 1-Oct-09 1-Nov-09 1-Dec-09 1-Jan-10 1-Feb-10 1-Mar-10 This is really very strange since the number of days in each month is different!!!!!!! You should reaqlly get 1/1/2009 2/1/2009 3/4/2009 4/4/2009 5/5/2009 6/5/2009 7/6/2009 8/6/2009 9/6/2009 10/7/2009 11/7/2009 12/8/2009 1/8/2010 2/8/2010 3/11/2010 "krishnan" wrote: Having given two dates is there any way to plot line from these two dates. ( say dates in continuous cells) Regards, Krish |
Thread Tools | |
Display Modes | |
|
|