View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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?