How to Recreate Three Popular Visuals from the Prestigious Consulting Firm, McKenzie, in Excel

📊McKenzie is known for creating visually appealing visuals in the consulting industry.

📈The radial bar chart in Excel can be used to create a visually stunning circular bar chart.

📊The unique bar chart created by McKenzie can be replicated in Excel by adjusting column widths and colors.

📊The stocked bar chart in Excel can be used to showcase the progression of data over time.

📚By recreating McKenzie's visuals in Excel, you can improve your data visualization skills and create engaging presentations.

Can I recreate these visuals in other spreadsheet software?

—Yes, the techniques shown in the video can be applied to other spreadsheet software as well.

Do I need advanced Excel skills to recreate these visuals?

—Basic knowledge of Excel functions and formatting is sufficient to recreate these visuals.

Where can I find the data set used in the video?

—The data set used in the video can be downloaded from the video description.

Can I customize the colors and styles of the visuals?

—Yes, you can customize the colors and styles of the visuals to match your own preferences and branding.

Are there any limitations to recreating these visuals in Excel?

—Excel has certain limitations when it comes to complex visualizations, but you can still achieve impressive results with the techniques shown in the video.

00:00McKenzie is a prestigious consulting firm known for creating visually appealing visuals in the consulting industry.

00:16The first visual to recreate is a radial bar chart, which can be done in Excel by adjusting column widths and colors.

06:32The second visual is a unique bar chart, where columns are nested inside each other. This can also be recreated in Excel by adjusting column widths and colors.

12:04The third visual is a stocked bar chart, which shows the progression of data over time. In Excel, you can create this by using a stocked bar chart and adjusting the axis options.