Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
combined scatter plot and line data
Hello How I display a line graph and a scatter plot on the same chart? Barry -- bmayers ------------------------------------------------------------------------ bmayers's Profile: http://www.excelforum.com/member.php...o&userid=35753 View this thread: http://www.excelforum.com/showthread...hreadid=555303 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
combined scatter plot and line data
1. Create a Scatter chart with the scatter data. 2. Highlight your line data and drag and drop the data onto the scatter chart. Select New Series as the option then click OK 3. Click on of the line chart datapoints, then right click. Select Chart Type and change it to Line chart 4. If you want to, you can put the line chart on the second Y axis by right clicking the line chart, and selecting Axis Second Y axis Matt -- Mallycat ------------------------------------------------------------------------ Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514 View this thread: http://www.excelforum.com/showthread...hreadid=555303 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
combined scatter plot and line data
Is this what you need, or do you simply need to remember that series in both
XY and Line series can be formatted to have lines or no lines, markers or no markers. The difference between line and XY charts is in the treatment of the X axis: http://peltiertech.com/Excel/ChartsH...ValueAxis.html http://pubs.logicalexpressions.com/P...cle.asp?ID=190 - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Mallycat" wrote in message ... 1. Create a Scatter chart with the scatter data. 2. Highlight your line data and drag and drop the data onto the scatter chart. Select New Series as the option then click OK 3. Click on of the line chart datapoints, then right click. Select Chart Type and change it to Line chart 4. If you want to, you can put the line chart on the second Y axis by right clicking the line chart, and selecting Axis Second Y axis Matt -- Mallycat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to add data points to a scatter plot with trend line | Charts and Charting in Excel | |||
how do I find the equation of a line using a scatter plot? | Charts and Charting in Excel | |||
Scatter plot and line graph combination | Charts and Charting in Excel | |||
How do I plot both line and column data on same graph? | Charts and Charting in Excel | |||
Line Graph Data Recognition | Charts and Charting in Excel |