Excel Sparklines in German: Create and Format Them

Charts & pivot tables · Updated November 21, 2026

In German-language Excel, sparklines are still called Sparklines: small charts placed inside worksheet cells to show a data trend at a glance. In Excel for Microsoft 365 on Windows, create one from Einfügen > Sparklines, choose Linie, Säule or Gewinn/Verlust, then specify the data range and the cell where the sparkline should appear.

What “Excel Sparklines deutsch” means

The search phrase can refer to two related questions: what sparklines are called in a German copy of Excel, and how to use the feature when the interface is set to German. The name is not translated into a wholly different chart feature. In the German ribbon, look for the Sparklines group on the Einfügen tab. The three chart types are generally labeled Linie, Säule and Gewinn/Verlust.

Some ribbon labels can vary slightly with the Office build, update channel or display language. If your commands appear in English, the equivalent route is Insert > Sparklines, followed by Line, Column or Win/Loss. The feature itself works the same way; changing Excel’s display language affects the interface, not the underlying data or the trend represented.

What a sparkline shows—and what it leaves out

A sparkline is a compact, in-cell visualization tied to worksheet data. It is useful when you want to compare many small trends beside row labels and figures without placing a full chart beside every record. For example, a sales table could show each product’s monthly values in columns B through M and a miniature trend in column N.

Sparklines are deliberately simpler than ordinary charts. They do not provide a full set of chart axes, titles, data labels or a legend. Their scale and visual detail are limited, so a line that rises slightly may look similar to one with a much larger increase unless you compare the actual values or adjust the axis settings. Treat the graphic as a quick visual summary, not a replacement for the numbers or a detailed chart.

  • Line connects values in sequence and is often suitable for time-based changes, such as monthly revenue.
  • Column displays a small vertical bar for each value, making individual highs and lows easier to compare.
  • Win/Loss emphasizes whether values are positive or negative, rather than how large their magnitudes are. It is useful for results such as wins and losses or periods above and below zero.

Create a sparkline in German Excel

Start with a rectangular set of data in which each row represents one item and the columns contain values in a meaningful order. For a simple example, put one product’s January-to-December figures in B2:M2 and leave N2 for its sparkline. The cell for the sparkline must be separate from the source values.

  1. Select the destination cell, such as N2.
  2. Choose Einfügen > Sparklines > Linie (or choose Säule or Gewinn/Verlust for another type).
  3. In the dialog box, enter or select the source values in Datenbereich, for example B2:M2.
  4. Check Positionsbereich and set it to the cell that should contain the miniature chart, such as N2. If you selected the destination first, Excel may fill this in for you.
  5. Choose OK, then adjust the appearance or axis if needed.

For several products, you can create a row of sparklines at once. If the source data occupies B2:M5, select N2:N5 as the destination range and use the same insertion dialog. The source and destination ranges must correspond: each destination row needs a matching row of values. Check the preview and the first and last results afterward, especially if your selection includes headings or totals by mistake.

Format and compare sparklines

After selecting a sparkline cell, Excel displays a contextual sparkline tab on the ribbon. Its displayed name may depend on the German interface version; look for controls for the sparkline type, style, marker options, axis and grouping. These controls affect how the in-cell graphic communicates the data, but they do not change the source values.

For a line sparkline, markers can call attention to individual observations. Options commonly include the first point, last point, high point, low point and negative points. A color for the line and a separate marker color can improve contrast. Column sparklines can use a different color for positive and negative values, while win/loss sparklines distinguish the direction of results. Use restrained colors if readers need to compare dozens of rows quickly.

Scale is important when comparing multiple rows. If each sparkline scales itself to its own values, a small fluctuation in one product can fill the cell just as dramatically as a large fluctuation in another. To make comparisons fairer, use the sparkline axis controls to set consistent minimum or maximum values across a group where the available options allow it. Conversely, an individual scale can make subtle changes within one series easier to see. State or document the choice if the graphic could otherwise mislead readers.

Excel can group sparklines so that formatting and axis settings apply together. A group is helpful for comparable rows, but it is not always appropriate when series have different units or very different ranges. If an edit unexpectedly changes several small charts, select one and check whether it belongs to a group. The contextual ribbon includes controls to group or ungroup selected sparklines; the precise German label can vary by version.

Data, blanks and hidden values

Sparklines depend on the source range, so changes to those cells update the graphic. Make sure the values are ordered correctly: a line sparkline follows the order of the cells in its source range, not dates inferred from their appearance. If months are sorted alphabetically rather than chronologically, the graphic will show that incorrect sequence. Dates and numbers should also be stored as usable values, rather than text that only looks numeric.

Blank cells can affect the appearance of a line. Depending on the sparkline’s data settings, Excel may show a gap, treat the blank as zero or connect the points across it. Choose the behavior that matches the meaning of the missing observation; a missing sales figure is not automatically the same thing as zero sales. Excel also provides a setting for whether data in hidden rows or columns is plotted. This matters when filtered or hidden records should still contribute to the visual summary.

When a sparkline looks empty, first check that its source range contains numeric values and that the location cell is not too narrow or the line color not too faint. Then inspect blank-cell and hidden-data settings. A worksheet may also have a calculation or data issue upstream; the sparkline does not repair or interpret inaccurate source data.

Common problems and practical fixes

  • The Sparklines commands are hard to find: Open the Einfügen tab and look for the Sparklines group. If the ribbon is simplified or the window is narrow, some groups or buttons may be collapsed. Widen the window or expand the ribbon.
  • The trend appears flat: Check the vertical axis scale. A large value elsewhere in the series can make smaller changes look nearly level; a common scale across rows can also flatten a low-range series.
  • One chart has the wrong values: Select the sparkline and review its data range in the sparkline editing controls. When creating several at once, verify that source and destination rows align.
  • A blank is drawn as a drop to zero: Change how empty cells are displayed in the sparkline’s data settings, or correct the source if zero is the intended value.
  • Colors or markers change together: The selected sparklines may be grouped. Ungroup them if they need independent formatting.
  • A printed or exported sheet is difficult to read: Increase the destination column width or row height, use a clear contrasting color and keep the actual values nearby. A tiny chart should not carry information that readers cannot verify.

Sparklines versus regular Excel charts

Choose a sparkline when the goal is to show a quick trend beside each row in a compact report. Choose a regular chart when readers need a title, labeled axes, a legend, data labels, several clearly distinguished series or more control over layout. A standard chart is also preferable when the magnitude and units need to be explicit, or when the graphic will be presented on its own.

The two approaches can complement each other. A summary table might use sparklines to let readers scan many products, while a larger line chart below it explores one selected product in detail. Avoid treating a sparkline as a miniature version of every chart feature: its value is that it keeps a simple trend close to the row it describes.

Language, version and sharing notes

The steps above target Excel for Microsoft 365 on Windows. On a Mac, the feature is also available from the Insert tab, but ribbon arrangement and localized labels may differ; look for the Sparklines group and the same three chart types. If your installation uses a different display language, use the corresponding translated ribbon labels rather than assuming that the data must be converted.

When sharing a workbook, the sparklines remain connected to their source ranges, so recipients should keep the relevant cells and workbook structure intact. If someone opens the file in another spreadsheet application, the appearance and editing support may differ. For a final report, check the workbook on the recipient’s intended platform and print or export a sample page to confirm that the small graphics remain legible.

Frequently Asked Questions

What is Sparkline called in German Excel?
It is generally called Sparkline or Sparklines. On the German Insert tab, look for the Sparklines group and the options Linie, Säule and Gewinn/Verlust.

Where do I insert a sparkline in Excel?
Select the destination cell, then choose Einfügen > Sparklines and select a type. Enter the source data range and location range in the dialog box, then confirm.

Can one sparkline show several rows of data?
A sparkline cell represents one series. To show several row trends, create a corresponding set of sparklines in adjacent cells, matching each destination row to its own source row.

Why does my sparkline not show the full size of a change?
The axis scale may make the values appear compressed, particularly when comparing series with different ranges. Review the axis settings and compare the graphic with the source numbers.

Can I use sparklines instead of a chart?
Yes, for a compact visual summary within a table. Use a regular chart when labels, axes, a legend or detailed comparisons are necessary.

Does changing Excel to German change the numbers in my workbook?
No. The display language changes menu labels, not the meaning of your source data. Number and date display can also depend on regional settings, so check those separately if values appear differently.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.