Thread: Modifying specific series in an overlayed chart

I currently have a stacked column graph with 5 series (A, B, C, D and E) with one series which is represented as a line chart (series A). Im wanting to change the entire graph, except series A, to a cluster column chart. When I attempt to change it, it changes all series to a cluster column.

Is there anyway to modify the chart so series B, C, D and E are changed to cluster column chart and series A remains as a line chart?

Thanks in advance.

Sample sheet attached.

If you click on one of the columns and right click, you'll get the option "Change Series Chart Type". That will affect only your columns and not your line. Does that work for you?