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

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?
 
S

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
 
J

jaysan3

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

X axis on 0 on Line-Column on 2 Axes 1
Make elements in a row space between instead of wrapping when choosing multiple columns 0
Changing the setting of X,Y axes 0
Excel 2007 Bar and Line chart on 2 Axes 3
graph column line graph with two axes 1
Line chart based on 3 columns 0
Overlay line graph points on bar graph 1
Column-Column on 2 axes 2

Top