Effects make your chart looks colorful or unique. In this tutorial, we explain how to create a Chart with Crayon effect in an Excel spreadsheet.

In addition to data organization, basic spreadsheet layouts, and performing calculations, Microsoft Excel can serve as a robust tool for making engaging, interactive dashboards.

To make McKinsey charts interactive, integrate dynamic Excel formulas that update the chart in real-time as the underlying data changes, transforming static visuals into interactive tools.

Use Excel’s combination chart feature to layer the total column behind the individual columns, creating a visually distinct representation of cumulative data.