Recommended Free Tools
iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
Introduction
A line graph is a visual representation of a set of data. This guide shows you how to make a line Graph in Excel.
How to Make a Line Graph in Excel (Single Data Set)
The image above shows a set of sales data for a business. It contains a single data set, sales data for a single year.
Follow the steps below to make a line graph for this data in Excel.
Outdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware matchWindows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstall- Select the data you wish to make the line graph for, including the column headers. Then click the Insert tab.
- Next, on the Recommended Charts section, click the chart drop-down [labelled 1]. Then select the chart you type.
- Once you make a selection, the chart will be displayed. You can reposition the chart by simply dragging and dropping it (more on this later).
How to Make a Line Graph in Excel with Two Sets of Data
The table in the image has 2 sets of data – sales for January to December for 2017 and 2018. Making a line graph in Excel with 2 sets of data is as straight forward as with a single data set.
Popular on Amazon
Follow the steps below to make a line graph with two sets of data:
- Select the data, including the headers. Then click the Insert tab.
- Next, click the Insert line chart option. Then select the chart type you wish to insert. The second image shows the chart.
How to Edit a Line Graph in Excel
After making a line graph, you may decide to make some changes. You can change the chart data, for example. You could also rename the title of the chart or even resize the chart.
To change the data of the line chart, follow the steps below:
The Tool Desk
Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Also popular on Amazon
- Double-click the cell containing the data you wish to modify. Then add a new value.
To resize the line chart in Excel, follow the steps below:
- Click on the line graph in Excel to highlight it.
- To resize the line graph, drag one of the circles inwards or outwards to shrink or expand it.
Finally, you can edit the name of the Excel line graph using the steps below:
- Click on the line graph title to highlight it.
- Next, delete the current name of the line chart and give it any name you wish.
How to Format a Line Graph in Excel
In the final part of this guide, I demonstrate how to format the line chart.
Also popular on Amazon
- Designed for Your Windows and Apple Devices | Install premium Office apps on your Windows laptop, desktop, MacBook or iMac. Works seamlessly across your devices for home, school, or personal productivity.
- Includes Word, Excel, PowerPoint & Outlook | Get premium versions of the essential Office apps that help you work, study, create, and stay organized.
- 1 TB Secure Cloud Storage | Store and access your documents, photos, and files from your Windows, Mac or mobile devices.
- Premium Tools Across Your Devices | Your subscription lets you work across all of your Windows, Mac, iPhone, iPad, and Android devices with apps that sync instantly through the cloud.
- Easy Digital Download with Microsoft Account | Product delivered electronically for quick setup. Sign in with your Microsoft account, redeem your code, and download your apps instantly to your Windows, Mac, iPhone, iPad, and Android devices.
To format the title of the line graph, follow the steps below:
- Click the chart title to select it. Then highlight the whole title.
- Next, click on the Home tab.
Finally, you can modify the colors of the line graphs.
Here is how you do that:
- Click on the line graph legend (highlighted in red below).
- Next, double-click the chart you wish to change its color. The Format Legend Entry options will be displayed.
- Click the forward arrow beside Border to expand it. You can modify the border fill options [1]. And/Or change the color [2]. In the second image below, the color of the line graph in Excel has changed to red.
Conclusion
Making line graphs in Excel is as straightforward as that! Hopefully, I have made life easier for you!
Also popular on Amazon
If you found the Itechguide helpful, kindly share your views at [discourse_topic_url]. If you have any questions or comments feel free to engage with other readers and staff at [discourse_topic_url].
Alternatively, you could share your experience making line graphs in Excel.
Quick wins for a faster PC:
Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Repair Windows errors before they cause bigger problemsFix Now →Quick Recap
Other Helpful Guides
- Absolute Reference vs Relative Reference Excel: Quick Guide
- How to Alphabetize (Sort Lists or Tables) in Microsoft Word
- How to Change Outlook Password in 2 Easy Steps
Additional Resources and References
- Present your data in a scatter chart or a line chart
- [discourse_topic_url].
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
