Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding to case quantities | Excel Discussion (Misc queries) | |||
getting quantities according to date | Excel Discussion (Misc queries) | |||
getting quantities according to date | Excel Worksheet Functions | |||
Spreadsheets--Adding Quantities | Excel Worksheet Functions | |||
Different quantities of a certain item... | Excel Worksheet Functions |