ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Scatter graph in Excel 2007 (https://www.excelbanter.com/charts-charting-excel/176655-scatter-graph-excel-2007-a.html)

LVM

Scatter graph in Excel 2007
 
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.

Jon Peltier

Scatter graph in Excel 2007
 
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
_______


"LVM" wrote in message
...
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.




LVM

Scatter graph in Excel 2007
 
Jon,
Thank you for responding! It worked!!

"Jon Peltier" wrote:

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
_______


"LVM" wrote in message
...
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.






All times are GMT +1. The time now is 09:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com