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
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 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 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 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 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 Beggiora
Ready! Take advantage of the tips for easily creating line charts in Excel from your PC.