Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple XY pairs in scatter plot Excel 2007 | Charts and Charting in Excel | |||
Excel 2007 crashing with simple scatter plots with 8 k data points | Charts and Charting in Excel | |||
Should I use a scatter graph? | Charts and Charting in Excel | |||
Excel 2007 Scatter Plot Freak Out! | Charts and Charting in Excel | |||
How do u set the PLOT AREA to nearest mm in Excel Scatter Graph . | Charts and Charting in Excel |