Create two curves with different time histories in same chart?
 

I have two time series with different sample intervals

I want to present the curves in the same chart

Create two curves with different time histories in same chart?
 

You can plot both series together in an XY chart. However, an XY chart
doesn't give as nice formatting options for dates along the axis (for
example, in a line chart you can have a tick mark and label at the first of
each month, but not on an XY chart). To preserve this, make a line chart
with both series, then select one, right click on it, choose Chart Type, and
select an XY type. If necessary, format the XY chart so it is plotted on the
primary axis with the line chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"OJ" wrote in message
...
I have two time series with different sample intervals

I want to present the curves in the same chart

Create two curves with different time histories in same chart?
 

Jon. Thanks for the prompt answer. I did almost the same - I made sure both
curves had same intervals and where there are no y-values I left it blank. I
used line interpolation at the end to ensure continuous lines.

All looks nice except that when Excel draws the graphs there is no relative
spacings used when setting up the x-axis. E.g. the intevals between e.g. 0.1
- 1.3 (0.2) and 0.6 and 0.9 (0.3) are drawn up with the same spacing along
the x-axis. I know this is not implemented in Excel, but maybe with your help
it will become a standard feature. It is common in many other commerical
tools and the feature is important for all engineers like me.


"Jon Peltier" wrote:

You can plot both series together in an XY chart. However, an XY chart
doesn't give as nice formatting options for dates along the axis (for
example, in a line chart you can have a tick mark and label at the first of
each month, but not on an XY chart). To preserve this, make a line chart
with both series, then select one, right click on it, choose Chart Type, and
select an XY type. If necessary, format the XY chart so it is plotted on the
primary axis with the line chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"OJ" wrote in message
...
I have two time series with different sample intervals

I want to present the curves in the same chart

Create two curves with different time histories in same chart?
 

Oh. Don't use a line chart at all, and don't muck up your data. Make an XY
chart, which recognizes independent sets of X data for each series. You can
format an XY series with the same options (markers, lines, colors, etc.) as
a line chart. The difference is in the treatment of X data and in formatting
options for the X axis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"OJ" wrote in message
...
Jon. Thanks for the prompt answer. I did almost the same - I made sure
both
curves had same intervals and where there are no y-values I left it blank.
I
used line interpolation at the end to ensure continuous lines.

All looks nice except that when Excel draws the graphs there is no
relative
spacings used when setting up the x-axis. E.g. the intevals between e.g.
0.1
- 1.3 (0.2) and 0.6 and 0.9 (0.3) are drawn up with the same spacing along
the x-axis. I know this is not implemented in Excel, but maybe with your
help
it will become a standard feature. It is common in many other commerical
tools and the feature is important for all engineers like me.


"Jon Peltier" wrote:

You can plot both series together in an XY chart. However, an XY chart
doesn't give as nice formatting options for dates along the axis (for
example, in a line chart you can have a tick mark and label at the first
of
each month, but not on an XY chart). To preserve this, make a line chart
with both series, then select one, right click on it, choose Chart Type,
and
select an XY type. If necessary, format the XY chart so it is plotted on
the
primary axis with the line chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"OJ" wrote in message
...
I have two time series with different sample intervals

I want to present the curves in the same chart