Financial Dashboard – best 4 dynamic excel charts

 

Created by: lulupatel

About Dashboard:

This dashboard shows company’s financial summary on industry estimated vs. actual revenue, revenue by region, estimated revenue. There are 4 dynamic charts.

This review is for the business owner who needs an intuitive financial dashboard on a daily basis, but more so, needs the ability to forecast and run scenarios to grow the company.

In today’s world, there is a huge pressure on the management to provide faster and transparent information, which helps in determining company’s overall performance. It tracks financial data, which helps to see the growth from various

perspective of the industry.

There are several ways in which you can visualize financial data to understand the company’s goal. In October, Excel Forum team launched a dashboard, competing in which you are asked to visualize financial data using sample data. The challenge has generated a huge thrill around the community and fetched 118 incredible entries.

In this article, we will show you the steps on how to create this dashboard.

Let us see how the Dashboard made by Lulupatel looks:

img1

We have divided this dashboard into 5 sections of information. Let us take a look at each one separately.

Section1:

In middle header of the dashboard there is a drop down list, which controls all the charts.

img2

In this section,yearly revenue comparison is shown for the last 3 years.

img3

The change from the previous year is calculated & shown by line chart.

Section2:

This section covers industry-wise regional revenue share. We can view the chart in ($000) & in %.

img4

If we click for cross-tab data then, we will get the other view of the dashboard.

img5

Section3:

The below chart shows region-wise revenue, yearly & quarterly, from the above drop down list.

img6

Section 4:

This section contains information the highlights of the selected year.

img7

Section 5:

The following chart shows stats by product & sales rep for the selected year.

img8

Using this dashboard we can get a clear view of the financial industry and thus we can get the information from various points of view.

Download Dashboard



One thought on “Financial Dashboard – best 4 dynamic excel charts

  1. Hi –
    I am thinking of starting a business intelligence project, starting with some dashboards for our CFO. I am really impressed with your work here.
    I would like to know if you are available for accepting my job as a freelancer and your costing for this.
    Regards,
    Sarath

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>