B
bmayers
Hello
How I display a line graph and a scatter plot on the same
chart?
Barry
How I display a line graph and a scatter plot on the same
chart?
Barry
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mallycat
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
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
J
Jon Peltier
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/ChartsHowTo/CatVsValueAxis.html
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=190
- Jon
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/ChartsHowTo/CatVsValueAxis.html
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=190
- Jon