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

A small dashboard with sparklines and slicers

An overview with twelve months of revenue per product is a wall of numbers. With sparklines, you add a mini chart in a single cell after each row, so you can see the trend at a glance. With a slicer, you get buttons to filter quickly by category. Together they form a small dashboard, without complicated charts.

As an example, we use Bloemisterij Het Zonnetje, with a category (column B) for each product (column A) and the revenue from January to December (columns C to N), in rows 2 to 8.

Step 1: insert sparklines

  1. Select the cells where the mini charts should go: O2:O8.
  2. On the Insert tab, click Sparkline. Three images appear: columns, a line and win/loss. Choose the middle one, the line.
  3. In the Create sparklines window, enter the numbers under Source data range: C2:N8. The location (O2:O8) is already filled in.
  4. Click OK.
The Sparkline menu
Insert, Sparkline: columns, line or win/loss
The Create sparklines window
Source data range C2:N8; the sparklines go in O2:O8

Each product now has a small line showing its trend over the year. Make the column a little wider and the rows a little taller to see more.

Step 2: highlight the highest and lowest month

Click a sparkline. The sparkline settings appear on the right, with options such as High point and Low Point under Show. Tick them and pick a colour if you like. You can see straight away in which month each product peaked. All sparklines you created together form a group and change along with it.

Sparklines with high point
Sparklines in column O; on the right, the settings with High point (1)

Besides Line, there are two other types. Column shows a small bar for each month. Win/Loss only shows whether a number is positive or negative: handy if you have a helper row with revenue minus target.

Step 3: buttons to filter with a slicer

A slicer works on a formatted table or a pivot table.

  1. Click in the data and turn it into a table: on the Home tab, choose Format as table template and a style, then click OK (see also A formatted table: column names in formulas, a total row and slicers).
  2. Click in the table and on the Insert tab, choose Slicer. You can also click Slicer on the Table Design tab.
  3. Tick Category and click OK.

A box appears with a button for each category. Click a button and the table shows only those products, including their sparklines. At the top of the slicer there is a multi-select button, which lets you turn on several buttons at once, and a button to clear the filter.

A slicer on Category
A slicer on Category next to the table with sparklines
The slicer in use
Click Planten: only the plants remain, with their sparklines. At the bottom it says 2 of 7 records filtered

Pitfalls

  • Deleting a sparkline with Delete does not work: the line simply stays. Right-click the cell and choose Sparklines; there you will find Clear selected sparklines and Clear selected sparkline groups.
  • A slicer filters for everyone: if you are working on the file with others, your colleagues will also see only the selected category. If you want to filter just for yourself, use a sheet view (see Filtering without bothering your colleagues).
  • You cannot use a slicer on an ordinary list. Turn it into a table first.
The right-click menu for a sparkline
Right-click a sparkline: the Sparklines menu with the clear options

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…