Visualization using excel

Occasional Visitor

How can we show in one graph line graph, stacked chart, and clustered chart using excel?

1 Reply


It's possible, but you have to rearrange the data, and display the series for the stacked column chart on the secondary value axis.

See the attached sample workbook, and see Create Excel Cluster Stack Charts