Changing Line to Bar when you have 2 axes

[Guest]

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.

 

[Echo S]

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.

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