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