Re: Excel should allow multiple X and Y scales for...

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jon Peltier (DOjonNOTxlmvp_at_SPAMpeltiertechME.com)
Date: 10/08/04


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).



Relevant Pages

  • Excel should allow multiple X and Y scales for...
    ... series have widely varied ranges, and I need multiple X-scales, stacked on ... reverse order) and the other parameters are on the X-axis. ... The only thing I can find in Excel is the ability to add a secondary Y-axis. ... scale. ...
    (microsoft.public.excel.charting)
  • Multiple X-Axis Values
    ... I am trying to graph data where the scale for the x-axis has multiple ... For example the value 3 also represents 76.2 on the x axis. ...
    (microsoft.public.excel.charting)
  • Re: Modularity problems with multiple dispatch
    ... It doesn't scale because there is no good way to select an f ... doesn't scale in the sense that you cannot simply dispatch on all ... which in turn means that *then* you wouldn't even care about multiple ... generics is that you can extend it everywhere so if fis ...
    (comp.lang.functional)
  • Re: Who Uses Multiple Contexts?
    ... The original context was Jon's recommendation that the OP use Multiple ... Jon did a good thing by trying to help the OP. ... multiple contexts. ...
    (comp.cad.solidworks)
  • Re: Modularity problems with multiple dispatch
    ... What do you mean by "too many problems" and "doesn't scale to multiple ... (no break of encapsulation) ... instance members can only be accessed within methods of the class ...
    (comp.lang.functional)