How to add series line in chart in Excel?
This tutorial is talking about how to add series line in chart in Excel, please read the follow details if you are interested in it.
Add sereis line in chart
It is very easy to add series line in chart.
Tip: You only can add series line in 2-D stacked Column/Bar, Pie of Pie or Bar of Pie chart.
1. Click at any place of the chart you want to add series line to show Chart Tools group in the Ribbon. See screenshot:
2. Click Layout tab, and select Series Lines from the Lines list. See screenshot:
Tip: In Excel 2013, click Design > Add Chart Element > Line > Series Lines.
Now the series lines are added.
Unlock Excel Magic with Kutools AI
- Smart Execution: Perform cell operations, analyze data, and create charts—all driven by simple commands.
- Custom Formulas: Generate tailored formulas to streamline your workflows.
- VBA Coding: Write and implement VBA code effortlessly.
- Formula Interpretation: Understand complex formulas with ease.
- Text Translation: Break language barriers within your spreadsheets.
Relative Articles:
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!