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
|
|||
|
|||
How do I set up S-curve
Hello Everybody,
I have a data in Excel 2003, What I want is to create a curve using that data. My question is, is it possible to have the curve from Jan-2009 to Dec-2009 if my value is from Jan-2009, Feb-2009, Mar-2009 & Apr-2009 is 100, 150, 200 & 250 successively but from May to Dec-2009 are all zero. However, I need the surve to be shown up to Apr-2009 only even the series ranges up to Dec-2009. How can I do this? Any help please. Thanks. Regards, Arnold |
#2
|
|||
|
|||
How do I set up S-curve
Make sure that the series that you are plotting includes NA() where data is
missing, instead of zero. -- David Biddulph "Arnold" wrote in message ... Hello Everybody, I have a data in Excel 2003, What I want is to create a curve using that data. My question is, is it possible to have the curve from Jan-2009 to Dec-2009 if my value is from Jan-2009, Feb-2009, Mar-2009 & Apr-2009 is 100, 150, 200 & 250 successively but from May to Dec-2009 are all zero. However, I need the surve to be shown up to Apr-2009 only even the series ranges up to Dec-2009. How can I do this? Any help please. Thanks. Regards, Arnold |
Thread Tools | |
Display Modes | |
|
|