Re: Chart different quantities vs. time
- From: "Jon Peltier" <jonxlmvpNO@xxxxxxxxxxxxxxxxxxx>
- Date: Sun, 24 Feb 2008 11:13:03 -0500
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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
"hmm" <hmm@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8193B966-5BB1-4871-8289-6D05D8F71DE4@xxxxxxxxxxxxxxxx
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?
.
- Prev by Date: Re: Graphing 20 months of data into 2 lines
- Next by Date: Re: xy scatter charts - multiple points
- Previous by thread: RE: How to copy a number into a text cell, keeping leading zeros?
- Next by thread: auto updating source data
- Index(es):
Relevant Pages
|
