Discover our latest report Investment Banking Software 2024: Challenges, Trends and Strategies

5 Ways to Make Beautiful Financial Charts and Graphs in Excel

Ella Hainsworth-Brear
Senior Consultant
April 15, 2024

Financial charts and graphs are the foundation of every pitchbook and report in the industry. To present data as clearly as possible for your clients and stakeholders, it’s vital to create Excel graphs and charts that help you tell impactful stories with your data.

In this blog, we share our top tips on how to build beautiful financial charts and graphs in Excel, with an insight on how finance teams are currently creating professional graphs and charts today.

If you’re looking for software that can help you build advanced Excel charts in a few clicks – go straight to our feature page.

Choose the Right Chart or Graph in Excel

What is an Excel Chart or Graph?

Excel charts and graphs are visual representations of data taken from your worksheets in Excel. Finance professionals use charts and graphs in Excel to represent different trends and highlight their analysis of various datasets.

Which Excel Chart or Graph Should I Use?

When building charts or graphs in Excel, it’s important to present your data in the best format.

A bar chart is especially useful for a portfolio analysis, whereas more complex charts like waterfall charts are better for displaying a cashflow analysis month-on-month. Using these Excel graphs in the right context will make your final deliverable look more professional and easier to understand.

What would you like to show in your beautiful Excel charts and graphs.
Consider what you would like your Excel graph to show: is it a relationship, a comparison, a composition, or a distribution?

How to Make a Chart or Graph in Excel

Every chart in Excel starts from the same place: the ‘Insert’ tab. Within this tab you have access to all 18 types of default charts that Excel offers.

Let’s say you wanted to make a bar chart in Excel:

  1. Select the desired data range in your workbook
  2. Head to the ‘Insert’ tab and select the bar chart option from the ribbon
  3. Select the bar chart you like best from the different options provided
  4. Just like that, you’ve built your first Excel bar chart
Build beautiful financial charts and graphs in Excel. The Charts menu in Microsoft Excel.

Top Tip

If you’re unsure of what chart to use in a specific scenario, use the ‘Recommended Charts’ feature within the ‘Insert’ tab of your Excel ribbon.

Adjust the Series Overlap and Gap Width on Charts

When creating bar charts or waterfall charts, Excel uses thin bars with wide spacing by default. We find the opposite works better as it makes it easier to visually compare data. The bars should be wider and the distance between the bars narrower. You can achieve this by adjusting the gap width and series overlap of your chart.

How to Adjust Gap Width and Series Overlap in Excel:
  1. Click on the data values within the chart you would like to edit. This will show the ‘Format Data Series’ pane.
  2. Click on ‘Gap Width’ – you want less white space but enough to differentiate between blocks

Did you know, with UpSlide you can automatically apply your default series overlap and gap width across all financial charts and graphs in Excel?

Make beautiful financial charts and graphs in Excel. Adjust series overlap and gap width.

Remove Background Lines from Graphs

When analyzing financial charts in Excel, there can often be a lot of data to interpret at first glance. That’s why most finance teams view it as best practice to remove all background lines from graphs in Excel to make the data as easy as possible.

Even with these two pie charts below, the default grid lines interfere with the chart design and the data we want to represent:

Make beautiful financial charts and graphs in Excel. Comparison of 2 pie charts, one with background lines removed.

How to remove gridlines on Excel charts:

  1. Head to the ‘Page Layout’ tab in your Excel ribbon
  2. Within the ‘Sheet Options’ section, find the ‘Gridlines’ column and untick ‘View

Once you’ve done this, the background lines will disappear across your whole workbook.

Remove Unnecessary Axes

Sometimes a second axis can be useful for data visualization in Excel. For example, if you wanted to represent data points as both a numerical value and also a percentage. However, if your second axis is overcomplicating your Excel charts for your final deliverable, it’s good to know how to remove it with ease.

To remove a second axis:

  1. Select the chart you want to edit.
  2. The ‘Chart Design’ tab will appear at the top of your ribbon
  3. Under ‘Add Chart Element’, click on ‘Axes’
  4. Then make sure to untick the ‘Secondary Vertical’ box
  5. You’ll no longer have a secondary axis on your Excel chart!
Make beautiful financial charts and graphs in Excel. How to untick the 'Secondary Vertical' axis to remove a secondary axis on your Excel graph.

Top Tip:

Always order your axis in descending or chronological order so it is simple, clear and easy to understand.

Add Clear Formatting to Your Excel Charts

Presenting your Excel graphs and charts with clear formatting is essential in making them look more professional. If you’re sharing financial charts as part of an internal report, it’s best-practice to format the charts into your company branding. In fact, for 78% of finance professionals, it is a prerequisite for deliverables to comply with their graphic charter.

If you’ve created Excel graphs and charts as part of an external client deliverable, we recommend formatting them into your client’s branding.  

How to format charts in Excel:

  • Select your desired chart in Excel
  • Next to the chart, select the paintbrush icon to edit the chart style
  • Apply the desired style presets under the ‘Style’ pop-up
  • Within the ‘Color’ pop-up you can also edit the color of each bar, line or segment in your chart

This will help you create professional graphs and charts in Excel for both internal and external deliverables.

Did you know, you can also convert PowerPoint slides and elements into clients’ branding with UpSlide?

How Finance Teams Are Building Beautiful Charts and Graphs in Excel

Colliers is a global real estate and investment management firm with over 18,000 professionals operating in 66 countries. Their Valuation & Advisory team provides valuation reports to a large number of financial institutions, private sector and government clients.

The team adopted UpSlide in 2020 to automate the creation of beautiful financial charts and graphs in Excel. Now their operators can make graphs in Excel with one click, and pre-apply their company branding across their whole workbook.

The Excel Formatting Tools have been key in empowering teams to create brand-compliant reports, quickly and easily. With UpSlide, we can apply our brand formatting to any Excel graph or table with a single click.

Jennifer Bailey

Operations Manager, Valuation & Advisory Services

UpSlide’s Excel Formatting enables finance teams like Colliers to standardize all charts across Microsoft 365 applications. They can build and format Marimekko, Waterfall, and Stacked Waterfall charts in one click, freeing up time for better data visualization and more strategic analysis.

It’s no wonder 39% of innovation leaders in the finance sector prioritize document management and automation to increase operational efficiency, save analysts time, and drive more deals.

Discover how to automate complex graphs and charts in Excel with UpSlide.

If you found this blog useful, bookmark our Knowledge Hub for more efficiency tips on how to work more efficiently in Microsoft 365.

TL;DR

  • Remove unnecessary elements that clutter the chart and make it harder to understand. For example, eliminate unnecessary axes.

  • Distribute bars evenly by making them wider and reducing the spacing between them. Additionally, remove background lines that can be distracting.

  • Finally, maintain consistency in your design choices by formatting all charts and graphs to your company’s graphic charter.

Ella Hainsworth-Brear
Ella is a Senior Consultant at UpSlide. Over the last 3 years, Ella has helped grow the consultant team within UpSlide UK, managing dozens of projects across leading financial and professional services companies. With a drive to help professionals work smarter, Ella creates customized solutions to address the unique needs of each client and ensure their success.

5 Effective Ways of Exporting Power BI to PowerPoint

Want to speed up report creation by connecting Power BI to PowerPoint? Discover five efficient...

Pitchbook Automation: Ultimate Guide to Creating Better Proposals

Tired of manual data embedding and endless rounds of reviews? Learn everything you need to...

Power Query: The 2024 Beginners’ Guide

Ever wondered what the Microsoft 365 add-in Power Query is and how it works? If...

Find out how UpSlide could help you and your teams