plot 4 time series in a common graph

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

moohwan
 
Moohwan said:
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.
Click to expand...

Select your first set of data (X & Y columns), insert the chart, then Add
Data & select your second set of data (choosing the "new series" option),
and similarly Add Data for your 3rd & for your 4th data sets.
Alternatively you can go into the Source Data menu, choose Add under
"Series", and add the X and Y value ranges there.
 
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
http://PeltierTech.com/
_______
 
Back
Top