Combined line chart and scatter chart

**sara ghaith** · 12-13-2012, 05:09 AM

hello,

I need to create a combined chart :
- Line chart for columns A, B & C
- Scatter with only markers chart for column D
- 8, 10 & 15 on the X axis

a b c d X Axis
100 150 170 200 8
300 8
400 8
200 250 270 150 10
250 10
350 10
300 350 370 230 15
330 15
340 15

i would really appreciate it if anyone could help

thanks in avance.

**Andy Pope** · 12-13-2012, 05:27 AM

create a line chart with all the data (A thru D) and then change the chart type of the last series.
You will need to move it to the secondary axis and add secondary horizontal axis

**sara ghaith** · 12-13-2012, 05:59 AM

thanks for the quick response, but maybe the data was miss understood in the table, so please find the attachment. I draw the 2 graphs that I need to combine to make it clearer