software

Hi

How could I plot 4 time series in a common graph?
I have four columns of Y data and have four sets of X data.
That is, I have four set of data where each are consist of a pair of X and Y.

thanks for your help in advance

moohwanquot;Moohwanquot; gt; wrote in message
news
gt; Hi
gt;
gt; How could I plot 4 time series in a common graph?
gt; I have four columns of Y data and have four sets of X data.
gt; That is, I have four set of data where each are consist of a pair of X and
gt; Y.

Select your first set of data (X amp; Y columns), insert the chart, then Add
Data amp; select your second set of data (choosing the quot;new seriesquot; option),
and similarly Add Data for your 3rd amp; for your 4th data sets.
Alternatively you can go into the Source Data menu, choose Add under
quot;Seriesquot;, and add the X and Y value ranges there.
--
David Biddulph
Note -

Use an XY chart. In a line chart, all series use the X values of the first
chart, and the values are generally not spaced according to value unless
Excel noticed they were dates and applied a time-scale axis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______

quot;David Biddulphquot; gt; wrote in message
...
gt; quot;Moohwanquot; gt; wrote in message
gt; news
gt;gt; Hi
gt;gt;
gt;gt; How could I plot 4 time series in a common graph?
gt;gt; I have four columns of Y data and have four sets of X data.
gt;gt; That is, I have four set of data where each are consist of a pair of X
gt;gt; and Y.
gt;
gt; Select your first set of data (X amp; Y columns), insert the chart, then Add
gt; Data amp; select your second set of data (choosing the quot;new seriesquot; option),
gt; and similarly Add Data for your 3rd amp; for your 4th data sets.
gt; Alternatively you can go into the Source Data menu, choose Add under
gt; quot;Seriesquot;, and add the X and Y value ranges there.
gt; --
gt; David Biddulph
gt;