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.

Figure B The Excel add-in inserts a chart populated with dummy data. How to connect the Excel data to the chart At this point, you’re ready to connect the chart to real data.

Figure H Our new PivotChart. This type of chart provides a lot of information, and thanks to Excel’s two pivot objects, you won’t have to jump through hoops to produce it.

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.