Re: Excel should allow multiple X and Y scales for...
From: Jon Peltier (DOjonNOTxlmvp_at_SPAMpeltiertechME.com)
Date: 10/08/04
- Next message: Jon Peltier: "Re: Bar Chart Question Multiple Elements"
- Previous message: Jon Peltier: "Re: chart with second y axis"
- In reply to: lfrey: "Excel should allow multiple X and Y scales for..."
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 08 Oct 2004 00:11:43 -0400
Here are some examples of what you are looking for. Once you know how to fake an
axis, you can visualize all kinds of possibilities.
http://peltiertech.com/Excel/Charts/StackedCharts.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
lfrey wrote:
> I am trying to create a chart which has several data series in it. The data
> series have widely varied ranges, and I need multiple X-scales, stacked on
> top of each other to properly display the data.
>
> This is a pretty common task in the Oceanographic community, as we typically
> have data plots which show various parameters (salinity, temperature,
> turbidity, etc) vs. depth, where depth is plotted on the Y-axis (values in
> reverse order) and the other parameters are on the X-axis. the other data
> series appear as multiple overlayed plots, each with a different X-axis
> scale.
>
> The only thing I can find in Excel is the ability to add a secondary Y-axis.
> There needs to be a way to add scales (axes) for each data series if
> necessary, in both X and Y, as well as have multiple series share the same
> scale (the way they do now).
- Next message: Jon Peltier: "Re: Bar Chart Question Multiple Elements"
- Previous message: Jon Peltier: "Re: chart with second y axis"
- In reply to: lfrey: "Excel should allow multiple X and Y scales for..."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|