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

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?

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

Hi,

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

Cheers,
Shane

"jaysan3" wrote in message
...
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?

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

It works. Thanks very much, Shane.

"Shane Devenshire" wrote:

Hi,

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

Cheers,
Shane

"jaysan3" wrote in message
...
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?