Quickly chart your data


The graphical format of a chart makes it easier to understand large quantities of data and the relationship between different series of data. You can start with a basic chart and then add attractive and eye-catching effects that emphasize just what you want.


  1. Select the data that you want to chart. The data should be arranged in rows or columns, with row labels to the left and column labels above the data. Excel automatically determines the best way to plot the data in the chart.

    Vælg data til diagram

  2. On the Charts tab, under Insert Chart, click a chart type, and then click the one that you want to add.

    Fanen Diagrammer, gruppen Indsæt diagram

  3. Click the Chart Layout tab to add titles, set axis options, add error bars, or other formatting that you want. Depending on the chart type, some options may not be available.

    Fanen Diagramlayout, gruppen Etiketter Fanen Diagramlayout, gruppen Akser Fanen Diaslayout, gruppen Analyse Fanen Diagramlayout, gruppen 3D-rotation

Tip: To get an idea of what you can add to or change in your chart, click the Charts, Chart Layout, and Format tabs, and then explore the groups and options that are provided on each tab. You can refine the look and impact of the chart by applying colors, styles, and shape effects. If you don't see the chart-related tabs, click anywhere in the chart to activate the tabs and then click the one that you want.

See also

Create a chart

Print a chart on a full page

Chart types

Edit data in a chart

Del Facebook Facebook Twitter Twitter Mail Mail

Var disse oplysninger nyttige?

Fantastisk! Har du mere feedback?

Hvordan kan vi forbedre det?

Tak for din feedback!