Chart different quantities vs. time

[hmm]

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?

 

[Jon Peltier]

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/ChartsHowTo/PanelUnevenScales.html

The first link is an easy intro, the second a bit more involved, but really
just what you need.
- Jon