combined scatter plot and line data

Hello

How I display a line graph and a scatter plot on the same chart?

Barry

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

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" <Mallycat.29xv0b_1151206502.2574@excelforum-nospam.com> wrote in
message news:Mallycat.29xv0b_1151206502.2574@excelforum-nospam.com...
>
> 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