Query: How to create Stacked column

Stacked column: A collection of data presented in vertical columns (shown on the X Axis and the Legend), demonstrating how each selected component is compared to its whole.

Stacked column Instructions - The sample chart uses the International Financial Statistics dataset and displays data for France's trade volume from 2009 through 2013.

Users may follow the steps below to replicate the following chart. 



Select Stacked column from View

Step 1: Select time
Step 2: Select country
Step 3: Select indicator
  • Click on the plus sign next to Legend and select Indicator       
  • In the Indicator attribute, click on  
  • From the pop up dialogue, do a right click, go to Hierarchy and select Default.  Thereafter, do the following: 
  • Click on National Accounts, then
  • Click on Expenditures, then
  • Click on Nominal, then
  • Click on External Sector, Nominal, then
  • Select the following indicators: "Exports of Goods and Services, Seasonally adjusted, Euros" and "Imports of Goods and Services, Seasonally adjusted, Euros".  Click Apply and OK. 

Hints: 
  • To quickly find an indicator, country or time period, use the provided search box. 
  • Place cursor over the 'play' icon to see the graph change over time or select each year separately to view it.
  • The system allows dragging and dropping variables between attributes (or by clicking on the wheel icon ) in the Data View pane for different results.

Feedback and Knowledge Base