Changing Line to Bar when you have 2 axes

C

Cara

I would like to have a graph where one y axis is represented by bars and the
other is represented by lines. However I can not find a way when I enter
the data to tell it whether to be a line or a bar.
 
E

Echo S

Cara said:
I would like to have a graph where one y axis is represented by bars and
the
other is represented by lines. However I can not find a way when I enter
the data to tell it whether to be a line or a bar.
Click to expand...

Go ahead and make a column chart with all your data. Then right-click one
series of bars, select Chart Type, and choose the line graph. This will
create the kind of combination chart you're after (although it's not
intuitive at all).
 
Top