Skip to content

Cookie settings

Choose which kinds of cookies you allow. You can change your choice at any time via Cookie settings at the bottom of every page. Privacy statement

Necessary

Always on

Needed to log in, keep your cart and remember your choices. These are always on.

Which cookies?
  • weboke_sessie, weboke_klant, weboke_remember: your session and staying logged in
  • weboke_basket: your cart
  • wkBtwIncl: showing prices with or without VAT
  • wok_cookies: your cookie choice, 12 months

Measures which ad leads to a visit or order, so we do not pay for ads that do nothing.

Which cookies?
  • Google Ads via Google Tag Manager (_gcl_au, _gcl_aw), up to 90 days
  • OpenAI Ads, ads in ChatGPT
  • wok_aff: which partner referred you to us (affiliate programme), 60 days

4.6

Country and language

Each country has its own site, with prices and VAT for that country.

View

Putting a chart from a spreadsheet in your presentation and keeping it up to date

Every month you give a presentation with the revenue figures: the figures are in a spreadsheet, and the chart needs to go in the presentation. You don't want to make the chart again every month. This article shows you the options and which one works best in your WebOké Nextcloud.

Example: Bloemisterij Het Zonnetje tracks its monthly revenue in the spreadsheet Revenue per month. Each month there is a presentation for the team meeting, with the revenue chart.

Three ways

MethodWhen
Link dataThe chart stays connected to the spreadsheet. After a change in the spreadsheet, you update the chart in the presentation with one click. The most convenient option for a monthly report.
Embed workbookThe figures are stored in the presentation, separate from the spreadsheet. Useful if you send the presentation to someone outside your WebOké Nextcloud.
Chart in the presentation itselfWith Insert, Chart you create the chart directly on the slide and keep the figures only there. Fine for a one-off chart.

Step 1: copy the chart from the spreadsheet

  1. Open the spreadsheet and create the chart if it isn't there yet: select the figures (for example A1 to B7), go to Insert, Chart and choose a type (see Creating charts).
  2. Click the edge of the chart so it is selected, and press Ctrl+C (Mac: Cmd+C).
The chart in the spreadsheet
Select the chart and copy it with Ctrl+C

Step 2: paste and link in the presentation

  1. Open the presentation, go to the slide where the chart should go and press Ctrl+V.
  2. A small (Ctrl) button with the paste options appears at the bottom right of the chart. Click it.
  3. Choose Use destination theme & Link data. This is also the default: if you simply paste, the chart is already linked. Choose Use destination theme & Embed workbook if you don't want a link.
The paste options for a chart
The (Ctrl) button (1) with Link data (2) and Embed workbook (3)

"Use destination theme" means the chart takes on the colours and fonts of your presentation, so it matches the rest of your slides.

Step 3: update the figures next month

  1. Enter the new figures in the spreadsheet and close the spreadsheet.
  2. Open the presentation. Euro-Office shows the message: "This presentation contains links to one or more external sources that could be unsafe." Click Update.
  3. The chart now shows the new figures.
The message about external links
Click Update (1) to fetch the latest figures

The message sounds alarming, but it's about your own spreadsheet. If the presentation comes from someone else and you don't know where the link points to, click Don't Update.

Updating while the presentation is open

Click the chart and open the Chart settings panel on the right. Under Linked Data you see the name of the spreadsheet. Click Update Data to fetch the latest figures.

The updated chart with the chart settings
Linked Data (1) with the name of the spreadsheet, Update Data (2) and Edit Links (3)

With Edit Links you open the External Links window. There you choose:

  • Update values: fetch the figures again.
  • Change source: intended for linking the chart to a different spreadsheet, for example the file for the new year. Afterwards, check that the chart shows the right figures.
  • Open source: open the spreadsheet.
  • Break links: remove the link, so the chart is no longer connected to the spreadsheet.
The External Links window
Update values (1), Change source (2) and Break links (3)

Pitfalls

  • The chart doesn't change: you clicked Don't Update when opening the presentation, or the spreadsheet was still open. Euro-Office only saves changes once everyone has closed the spreadsheet (see You don't see your changes when you download the file or open it on your computer). Close the spreadsheet, wait a moment and click Update Data in the presentation.
  • Someone else opens the presentation: the link only works if that person can also access the spreadsheet. Share the folder containing both files.
  • The presentation goes to someone outside your organisation: first remove the link with Break links, or paste the chart with Embed workbook. That way the recipient won't get a message about external sources either.
  • New month, new row: if you add rows to the spreadsheet, check in the spreadsheet that the chart includes the new row (see Creating charts).

You create a chart with columns and a line on a secondary axis in the spreadsheet (see A chart with columns and a line on a second axis) and copy it in the same way. To pull figures from another spreadsheet into a spreadsheet, see Cellen koppelen aan een andere spreadsheet in je Nextcloud.

One moment…

Set up your domains

For each domain, arrange the nameservers, the link to your hosting and who becomes the owner.

Loading your domains…