Re: overlaying xy plots on same axis

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

Thanks for tip. It quickly yielded what I needed. In hindsight, approach should of been obvious to me.

Windsurfer LA

Jerry W. Lewis wrote:
If you highlight more than 2 columns when creating the chart, the first column will be interpreted as the x-values and all subsequent columns will become separate data series on the same axes. Alternately, Chart|Add Data will allow you to add extra data series.

Jerry

windsurferLA wrote:

I want to be able to show the magnitude and orientation of two vectors as a function of an independent variable (time). I can generate an appropriate image for any one vector using an xy plot. I have been able to create the effect that I want by generating two graphs with transparent plot areas, but I am having great difficulty keeping the two independent plots precisely aligned. (If I copy and paste one over the other, they're initially aligned, but it is not clear how to select one and not the other to change the source data range.)

Is there a way in Excel97 to have the program automatically place two independent xy plots on the same set of axes?

If one stacks two independent graphs, what determines the placement of the plots regards to foreground - background? If you have two graphs on a sheet, what determines which graph is in front of the other?

Thanks in advance... Windsurfer in LA 


.

Relevant Pages

  • Re: overlaying xy plots on same axis
    ... If you highlight more than 2 columns when creating the chart, the first column will be interpreted as the x-values and all subsequent columns will become separate data series on the same axes. ... I have been able to create the effect that I want by generating two graphs with transparent plot areas, but I am having great difficulty keeping the two independent plots precisely aligned. ...
    (microsoft.public.excel.charting)
  • Re: Keeping axes constant
    ... How the heck do I keep axes of subsequent graphs constant? ... three plots. ... here I obviously can state axis limits after every ...
    (comp.soft-sys.matlab)
  • [ANN] Veusz 0.10 - a scientific plotting pacakge
    ... Veusz 0.10 is now available. ... within other Python programs or called externally. ... different graphs including XY, histograms, images and contour plots. ...
    (comp.lang.python.announce)
  • Re: Align graphs in multiplot
    ... > Is there a simple way to achieve an automatic alignment of several ... > graphs in multiplot even with variable font sizes? ... "postage stamp plots" (because the individual plots have such a strong ... But how can I ensure that the borders of the graphs just ...
    (comp.graphics.apps.gnuplot)
  • overlaying xy plots on same axis
    ... I want to be able to show the magnitude and orientation of two vectors as a function of an independent variable. ... I have been able to create the effect that I want by generating two graphs with transparent plot areas, but I am having great difficulty keeping the two independent plots precisely aligned. ...
    (microsoft.public.excel.charting)