Visualisations in LocalFocus

Turn datasets into stories in 5 steps: LocalFocus enables you to create insightful data visualisations from every table. Simple and fast. Nog geen account in LocalFocus?

Get to work with Visualisations in LocalFocus

Copy-paste the dataset

Create a new visualisaton in LocalFocus. Copy your table from Excel (or any other spreadsheet program) and paste it into the empty text field.

View the dataset | View the result in LocalFocus

The numbers

It's all about the numbers when you paste a table in LocalFocus. Leave contextual information like a title or source out and remove empty rows. You will put your data visualisation into context in step 4. You do copy-paste the column titles, those are needed to identify the numbers.

The numbers

Handy Excel formulas

Calculate rate:

= part / total * 100

Amount per 1.000 persons:

= number of incidents / population * 1000

The dimensions

The software of LocalFocus recognizes dimensions and values in your dataset. The values in LocalFocus are selected by equality. This means the software needs a value for every combination of dimensions in the table.

Check the dataset

Our platform automatically makes an estimate of your dataset. Are the decimals separated by periods or commas? Which row contains the locations you want to put on your map? You only have to check this information.

View the dataset | View the result in LocalFocus

Regional divisons

LocalFocus offers several regional divisions inside and outside the Netherlands. Read more about regional divisions and how to connect your data to this map in this blogpost.

All regional divisons in LocalFocus

Regional divisons

Municipal reorganisation

Municipal reorganisations take place yearly in the Netherlands. LocalFocus offers all municipal regions since the reorganisation in 2008. Choose the right municipal regions when you upload your data. Different municipal regions in one dataset? No problem, LocalFocus will select the right one based on the time slot.

Municipal reorganisation

Date formats

Our platform recognizes different date formats in datasets. Within the date formats, hyphens ( - ) can be changed to slashes ( / ), periods ( . ) or spaces. Read about all possible date formats in this blogpost.

All possible data formats in LocalFocus

Date formats

Choose the right chart

While one story is displayed clearly in a line graph, the other story asks for a map. You will explore possible visualisations in this lesson, based on the story you want to share.

View the dataset | View the result in LocalFocus

Horizontal bar chart

The horizontal bar chart is pre-eminently suited to display a ranking. The values can easily be compared on the basis of the length of the bars.

Horizontal bar chart

Column chart

The column chart is ideal to show developments over time and works best with a minimal number of data points.

Column chart

Line graph

A line graph is just like the column chart most suitable for displaying trends. In most cases, you will want to start the y-axis at zero to prevent a distorted graph, but there are exceptions.

Shut up about the y-axis. It shouldn't always start at zero.

Line graph

Pie chart

Pie charts and stacked bar charts show proportions. Make sure all values add up to a logical total value. When you want to compare values, choose a bar chart.

Pie chart

Maps

Maps can be used to show geographical patterns. In the previous lesson, we show you which regional divisons LocalFocus offers.

Tool for map colors

Maps

Put your data visualisation into context

Modifying the colors of your visualisation, enables you to emphasize specific information. Add annotations to clarify notable figures and a contextual title will show the audience why these numbers are relevant in the first place.

View the dataset | View the result in LocalFocus

Titles!

The title of your datavisualisation is as important as the title of your article. Explain your audience why this visualisation matters. Text and visuals should reinforce each other.

Titles

Colors

You can use colors to emphasize specific datapoints. For example, giving the country's average another color in your bar graph will make it more clear which regions score below or above average.

Tool for choosing map colors

Colors

Annotations

Annotations give your visualisation extra context and enable you to clarify trends, patterns or outliers.

Annotations

Publish your data visualisation

As soon as your story is finished, you can publish the graph or map on your website. It is also possible to download your graphs and maps as png or vector file.

View the dataset | View the result in LocalFocus

On your website

You generate an iframe-code in one click. With this code, you can embed the interactive graph on your website. Make sure the width is set to 100 percent, then the visualisation will be displayed correctly at al screen sizes.

Op jouw website

At social media

Png images can be used at social media channels like Twitter and Facebook. This article will help you to select the right size.

List of all social media image sizes

At social media

For print

With one click at the button pdf or svg, you download your visualisation in a vector file. The elements in your visualisation are loose objects and can therefore be easily edited in programs like Illustrator or Inkscape.

Inkscape for (free) editing

For print