Defending Dignity A Manual for National Human Rights Institutions on Monitoring Economic, Social and Cultural Rights You can build column or bar charts in Excel by following these steps: 1. Filter and sort the data you are interested in visualizing (sorting by ascending or descending order makes the chart easier to read). 2. Select the data you want to use to create the chart and select “Column” from the “Insert” tab at the top of the page. Experiment with the “Chart layouts” and “Chart styles” settings to remove or reposition the legend, change the colour of your columns and so on. You can also change it to a bar chart using these settings. You can also experiment with other types of chart by following the same instructions. 15.2.2. Line charts Line charts are appropriate when you have categories and values over time (e.g. unemployment rates by age groups from 2004–2014). The values will remain on the “Y” axis, with time on the “X” axis. For example, you might want to show the evolution of youth unemployment over the past ten years. You can also add multiple lines to the chart and you could compare the trend in youth unemployment with that of total unemployment. 148