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

  • Thread starter Thread starter jaysan3
  • Start date Start date
J

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?
 
Hi,

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

Cheers,
Shane
 
It works. Thanks very much, Shane.

Shane Devenshire said:
Hi,

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

Cheers,
Shane
Click to expand...
 
Back
Top