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