contador web Saltar al contenido

How to make line chart in Excel | Productivity

Excel lets you produce line charts from spreadsheets in a few clicks. The user must select the table with the data and click a button to insert the chart automatically. Once generated, you can customize the colors and design of the chart, as well as formatting fonts and shapes.

In the following tutorial, learn how to graph a line in Excel from your computer. The procedure was performed on the latest version of Office 2016, but the tips also apply to users of previous editions of the Microsoft program.

Seven Excel Functions Little People Know

How to create charts in Microsoft Excel

How to create charts in Microsoft Excel

Want to buy a cell phone, TV and other discounted products? Meet the Compare TechTudo

Step 1. Select the chart data table. Then on the "Insert" tab, select the line chart icon and choose the type of chart you want to use;

Inserting a line chart in Excel Photo: Reproduction / Helito BeggioraInserting a line chart in Excel Photo: Reproduction / Helito Beggiora

Inserting a line chart in Excel Photo: Reproduction / Helito Beggiora

Step 2. The selected chart will be inserted over the table and you can freely drag it on the spreadsheet. To change the size of the chart, use the points located above the outline;

Resizing chart Photo: Reproduction / Helito BeggioraResizing chart Photo: Reproduction / Helito Beggiora

Resizing chart Photo: Reproduction / Helito Beggiora

Step 3. Select the chart to customize it. In the "Design" tab you can add elements, change the layout, change the colors and style of the graphic and more;

Customizing graphic design Photo: Reproduction / Helito BeggioraCustomizing graphic design Photo: Reproduction / Helito Beggiora

Customizing graphic design Photo: Reproduction / Helito Beggiora

Step 4. Double click on "Chart Title" to edit the content and write a title for your chart;

Editing graphic title Photo: Reproduction / Helito BeggioraEditing graphic title Photo: Reproduction / Helito Beggiora

Editing graphic title Photo: Reproduction / Helito Beggiora

Step 5. In the right column, choose the part of the chart you want to customize. You can change the fill and outline color of shapes, caption formatting and chart title, and more from the side menu.

Chart formatting options Photo: Reproduction / Helito BeggioraChart formatting options Photo: Reproduction / Helito Beggiora

Chart formatting options Photo: Reproduction / Helito Beggiora

Ready! Take advantage of the tips for easily creating line charts in Excel from your PC.