Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
"Moohwan" wrote in message
... 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. 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. -- David Biddulph |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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/ _______ "David Biddulph" wrote in message ... "Moohwan" wrote in message ... 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. 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. -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
plot multiple time series | Charts and Charting in Excel | |||
Adding series, this time with a 2 axes line chart | Charts and Charting in Excel | |||
How can I "break" the bar in a graph if a series is off the chart | Charts and Charting in Excel | |||
How to exclude weekends/holidays from plotted time series | Charts and Charting in Excel | |||
xy scatter graph with a scrolling time element | Charts and Charting in Excel |