FIX THE PITCH

×

Fix the Pitch

How to craft compelling, dazzling pitchbooks. Thoughts, ideas, and inspiration to help construct advanced financial analysis, build stunning data visualizations and tips for mastering client meetings.

Popular tags


Benchmarking pitchbook charts: Spotting trends and showing change

Eric RattnerEric Rattner


Eric Rattner

Chief Content Officer, Eric Rattner, shares his thoughts on benchmarking charts series and how they should be used.

Why use a benchmarking chart?

Bankers love to benchmark; pretty much every pitchbook will have at least a few benchmarking analyses. This is because benchmarking offers a very clean and elegant way to compare and rank entities across metrics. Using different treatments, you can pull out a range of insights, such as how a subject company compares to its peers, an industry index, or to a market index more generally.

What types of data work best in a benchmarking chart?

Again, one of the great things about benchmarking charts that you can use them to offer a comparison across any normalized metric. At Pellucid, we have even developed compound versions that allow for comparisons across multiple metrics in a single chart.

What are the main visual variations of a benchmarking chart?

I have developed five archetypes, from which over 70 product variants available. Each can be further customized with data, appearance, and size options to create literally billions of different pitchbook exhibits. The main archetypes are:

When would you use an arrow benchmarking chart?

The arrow benchmarking bar chart archetype is useful to show change over a defined period of time. The horizontal arrow for each company reflects the metric change (the longer the line, the greater the change) and the diverging stack of the lines show how the entities compare over the metric range.

How long would it typically take to create these benchmarking charts in Excel?

A basic benchmarking chart is actually pretty easy to create in Excel, which is partly why they are so ubiquitous in pitchbooks. But, the more complex the chart, the more of a challenge it is to create. For instance, a linked compound chart would take about 2 hours to make. But, as with anything produced in Excel, sometimes the pain of creation is not the amount of time it takes to initially create content, but the time required to update and edit the content and get it pitchbook ready. Pellucid has developed solutions to these issues so that content can be easily created and edited.

Are there any benchmarking chart “gotchas”?

Benchmarking charts are deceptively simple and there are a few things that bankers should look out for when creating the charts in Excel.

Explore Pellucid’s content, created specifically for pitchbooks and financial analysis. Request a consultation.

Eric Rattner
Author

Eric Rattner

Investment banking lifer and native New Yorker. Broadway and movie buff and aspiring soccer star. Building innovative, beautiful charts filled with really smart data analysis.

Comments