How to change bar to line in line-column on 2 axes chart in Excel2

[jaysan3]

I have 3 series of data - Qty, TAT & Target. I would like Qty to be bar while
other 2 to be line on seperate axes. When I select custom type line-column on
2 axes, it will give me Qty & TAT as bar while Target as line. How do I
change TAT to line?

 

[Shane Devenshire]

Hi,

Single click the series you want to change and choose Chart, Chart Type and
pick the chart type you want.

Cheers,
Shane

 

[jaysan3]

It works. Thanks very much, Shane.

Hi,

Single click the series you want to change and choose Chart, Chart Type and
pick the chart type you want.

Cheers,
Shane