Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
plot multiple time series
Hi. everyone
I am stuck with plotting several time series on a common graph. I have two functions: y_t=0.5y_t-1+e_t y_t=1.5y_t-1+e_t there is a single shock (e_0 0) and ignore e_t. would ypu help me out? moohwan |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
plot multiple time series
You need X and Y values to generate a plotted curve. In one column, enter
your X values. For your formulas, these might be just consecutive integers. In the next column, enter formulas that calculate the Y values. Since you have two series to plot, you need two columns of Y data; in general you might have two sets of X data, but your formulas look like they'd both use the same X values. Select the range of data (one column X and two columns Y), and start the chart wizard. Choose the XY chart type, I suspect you want one of the variations that connect the points with lines. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Moohwan" wrote in message ... Hi. everyone I am stuck with plotting several time series on a common graph. I have two functions: y_t=0.5y_t-1+e_t y_t=1.5y_t-1+e_t there is a single shock (e_0 0) and ignore e_t. would ypu help me out? moohwan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple scatter graphes how to plot 3 sets of data for x y on th. | Charts and Charting in Excel | |||
Graphing A Time Series of Multiple Stock Prices | Excel Worksheet Functions | |||
In excel scatter plot with 2 series, how do I connect xy coordinat | Charts and Charting in Excel | |||
Plot points with same x-value in same series? | Charts and Charting in Excel | |||
How to exclude weekends/holidays from plotted time series | Charts and Charting in Excel |