Brilliant! Thanks, Andy.

Cheers,

Shawn

"Andy Pope" wrote:

Hi,

Select the series and then right click, on the popup menu select chart
type and then pick the required line chart.

Or select the series and then from the menu Chart Chart Type, select
the required line type.

Cheers
Andy

yadernye wrote:
How do I change a series from a bar to a line in a mixed bar-line chart?

--

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