Two axis Scatter plot

D

Dan

I am trying to plot a simple two series (velocity and
acceleration) vs. Time on a single scatter plot. How can
i do that? Essentaially the x axis would be time (from 100-
500). The first Y axis on left would be Velocity (from 20-
50), and the second Y axis would be on the right (from 200-
300). All on one scatter or line plot.

This seems harder to do than i thought. Any help would be
appreciated. Thanks.

- Dan
 
J

Jon Peltier

Dan -

Don't give up. I assume your data is together on one worksheet, say time
in column A, velocity in B and acceleration in C. Select the data, start
the chart wizard, and make an XY Scatter Chart. Double click on the
Acceleration series, and on the Axis tab, select the Secondary Axis option.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Non Linear Scatter plot, need to find y value 3
Use text descriptors as Y axis units 1
Scatter plot 1
Scatter plots in excel 2007 1
switching the axes, categories to values and vice versa 0
Plotting Date and Time on the same chart axis 1
X-Axis Appearing in Plot Area 2
Making Equal Spacing between --> X-Axis = Y-Axis, in a char 1

Top