Skip to content

Query: How to create Stacked column

← Help Documents and References
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 below chart. 



Select Stacked column from View

Step 1: Select time: 
  • Click on the plus sign next to X Axis and select Time
  • Place cursor over Time and click on  "T"  
  • From the pop up dialogue box select 2009 to 2013. Click Apply and OK. 
  • ??For detailed instructions: ?How to select time and frequency
Step 2: Select country: 
  • Click on the plus sign next to Legend and select Country
  • Place cursor over Country and click on "T" 
  • From the pop up dialogue box select France. Click Apply and OK. ?
  • For detailed instructions: ?How to select countries
?Step 3: Select indicator: 
  • Click on the plus sign next to Legend and select Indicator       
  • Place cursor over Indicator, and click on  "T"
  • From the pop up dialogue 
  • ?select National Accounts, then
  • select Expenditures, then
  • select Nominal, then
  • select 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

(thinking…)