how do I change a line series to a column series in excel?

Iam wanting 1 line series and 4 column series in my chart. All I keep getting
is 3 column series and 2 line. I can not figure out how to change a series
type?

Hi,

Simplest way is to create a normal column chart using all 5 series of
data. Then right click the column you want as a line. From the popup
menu choose Chart Type. Select the required line chart style.

Cheers
Andy

Mati wrote:
> Iam wanting 1 line series and 4 column series in my chart. All I keep getting
> is 3 column series and 2 line. I can not figure out how to change a series
> type?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info