XLSTAT: Bar chart with images in Excel

 

Dataset For Example

The (attached) data represents the percentage change of the Q1 - 2021  Gross domestic product (GDP) compared to the previous period. A sample of 10 countries has been taken.  Source: OECD (2021), Quarterly GDP (indicator). doi: 10.1787/b86d1fc8-en

For this example, the aim is to visualize the GPD variation per country. We will create a bar chart to graphically illustrate the percentage change and by using XLSTAT’s flag library we will add images to the chart for a better presentation.

 

Setting Up

• Open XLSTAT.

• Click on the Visualizing data menu and select the Bar charts feature.

In the General tab:

• Select column A in the Labels field and column G in the Values field.

• Since labels correspond to the codes of the countries, choose Countries (codes). Note: the XLSTAT flags library will be automatically used to identify the appropriate flag.

In the Options tab:

• Select the Horizontal in the Bar field.

• Use the country names as the axis labels.

• Display the flags next to the axis in circles.

 

• Click on the OK button to launch the computations.

• The results are displayed on a new Excel sheet.

 

Interpreting the Results

Given the bars length and variation values, we observe the highest positive GPD change for India and the highest negative GPD change for Germany.

It is also possible to:

• display the bars vertically
• add the countries' codes
• use your own images as a background of the bars