Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Moohwan
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
multiple scatter graphes how to plot 3 sets of data for x y on th. frances Charts and Charting in Excel 3 May 2nd 23 11:42 AM
Graphing A Time Series of Multiple Stock Prices carl Excel Worksheet Functions 1 June 25th 05 11:15 AM
In excel scatter plot with 2 series, how do I connect xy coordinat Anne-SFRunner Charts and Charting in Excel 2 March 4th 05 07:07 AM
Plot points with same x-value in same series? smKing Charts and Charting in Excel 1 February 3rd 05 07:32 PM
How to exclude weekends/holidays from plotted time series Debbie424242 Charts and Charting in Excel 3 January 19th 05 07:00 PM


All times are GMT +1. The time now is 03:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"