Scatter graph in Excel 2007

L

LVM

I need to make a scatter chart for Kinetic energy and potential energy (both
on the Y axis) with height on the X axis. I cant seem to do this. my data
should cause the PE and KE to cross over like an X but I cant get it to plot
both.

Thanks.
 
J

Jon Peltier

Use three columns for your data, with the X value in the first column. Put
labels above your Y data columns, but leave the cell above the X data blank.
Now select the data and create the chart.

- Jon
 
L

LVM

Jon,
Thank you for responding! It worked!!

Jon Peltier said:
Use three columns for your data, with the X value in the first column. Put
labels above your Y data columns, but leave the cell above the X data blank.
Now select the data and create the chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - 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

Top