course bg
EduPristine>Blog>Financial Modeling and The Economist

Financial Modeling and The Economist

January 6, 2014

While exploring the worldwide GDP results, I happened to come across a graph from The Economist.
I was fascinated, rather intrigued too see how MS-Excel could be used to convert the big boring data into a spectacular presentable form. And now, I present a small tutorial on how you can make these kinds of graphs for the data you have.
NOTE: *All the data used below is purely hypothetical.*

Make the spreadsheet of the data that you are holding.

Select the range of data that you want in the column graph. Go to Insert Column 2-D column stacked column
The result will be obtained as above.

Now you may wish to add any data to the chart, let us assume the data under TOTAL was not entered.

Then, right click anywhere on the obtained chart and go to SELECT DATA. A dialogue box, as shown below, will appear.

Under the legend entries, click on ADD tab. A new dialogue box will appear. Under the series name, write total. And for the series value, select the ‘TOTAL’ row from the spreadsheet.

Save the changes. The new graph will look like the image below.

Now to obtain the line graph for ‘Total’, select ‘total’ on graph. Right click on the ‘total’. Follow Change series chart type X Y scatter scatter with smooth lines.

The new graph obtained will look like the image below.

Now to reach our final graph, only thing that’s left to be done is the formatting part.

STEP 1 : To remove the grid lines, select the grid lines and press DELETE.

STEP 2 : To shift the legend downwards, right click on the legend format legend choose the bottom option in legend options.

STEP 3 : To change color of columns of each country, select the individual country, right click Format legend entry Fill select the color.

STEP 4 : To change background for the chart, right click on any vacant space in the chart Format chart area fill solid fill choose the color.

STEP 5 : To change background for the plot are, right click on any vacant space in the plot Format plot area fill solid fill choose the color.

The final graph would appear like the image below.

Thus, an attempt has been made to present to you, a method for plotting graph that would make your data look more presentable.

About Author

avatar EduPristine

Trusted by Fortune 500 Companies and 10,000 Students from 40+ countries across the globe, it is one of the leading International Training providers for Finance Certifications like FRM®, CFA®, PRM®, Business Analytics, HR Analytics, Financial Modeling, and Operational Risk Modeling. EduPristine has conducted more than 500,000 man-hours of quality training in finance.

Comments

Interested in this topic?

Our counsellors will get in touch with you with more information about this topic.

* Mandatory Field

`````````````````````````````````````````````````` Post ID = 43215