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?

Hi,

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

Cheers,
Shane

"jaysan3" <jaysan3@discussions.microsoft.com> wrote in message
news3D5B6F7-2C85-46F2-8A63-59D2CBA0DD34@microsoft.com...
> 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?

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" <jaysan3@discussions.microsoft.com> wrote in message
> news3D5B6F7-2C85-46F2-8A63-59D2CBA0DD34@microsoft.com...
> > 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?
>
>