Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to Add Series Line in Chart in Excel?
A series line in Excel helps us to connect the data objects of same time period. A series line helps us to analyse the charts more efficiently without any confusion. A series line connects the data objects of same rows with a line. Generally, series lines are added to the stacked or 100 stacked columns. In this tutorial, we will demonstrate how you can add series lines in a chart in Excel.
Adding Series Line in an Excel Chart
Let us suppose we have an Excel sheet with the following data:
Step 1
To create the chart, select the data → click Insert → select Stacked Column Chart under the Chart section. It will create a stacked column chart, as shown below:
Step 2
To add the series lines, click the chart → Chart Design → Add Chart Element → Lines → Series Lines. See the screenshot shown below:
Our final result will have the series lines added successfully, as shown in the following image.
We can also customize the colour and width of every line just by right-clicking on the line and selecting Format from the menu box. In the Format box, we can adjust the colour, width and transparency of the line in a simple way.
Conclusion
In this tutorial, we demonstrated how you can add Series Lines to a Chart in Excel.
1K+ Views
