Create two curves with different time histories in same chart?

  • Thread starter Thread starter OJ
  • Start date Start date
O

OJ

I have two time series with different sample intervals

I want to present the curves in the 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. 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.
 
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
 
Back
Top