Chart different quantities vs. time
 

I want to chart several different quantities vs. time, allowing at-a-glance
observation of correlated trends. Putting all the data series in one chart
will look far too busy (not to mention the variations in scale). Instead, I
want to display several charts, stacked one above the next. The x-axes would
all be identical, but each y-axis would be scaled according the range of
values. How can I do it in Excel?

Chart different quantities vs. time
 

You can do it with multiple charts, as you suggested, with near-matchup of
the X axes. Or you could make a panel chart:

http://peltiertech.com/Excel/Charts/StackedCharts.html
http://peltiertech.com/Excel/ChartsH...venScales.html

The first link is an easy intro, the second a bit more involved, but really
just what you need.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"hmm" wrote in message
...
I want to chart several different quantities vs. time, allowing at-a-glance
observation of correlated trends. Putting all the data series in one
chart
will look far too busy (not to mention the variations in scale). Instead,
I
want to display several charts, stacked one above the next. The x-axes
would
all be identical, but each y-axis would be scaled according the range of
values. How can I do it in Excel?