Skip to main content

Kutools for Office — One Suite. Five Tools. Get More Done.

Easily add a trendline for multiple series in a chart in Excel

Author Siluvia Last modified

Kutools for Excel

Boosts Excel With 300+
Powerful Features

When creating a scatter chart to compare at least two sets of values, you may need to add a trendline for the series to visualize the general trend. Kutools for Excel provides a handy chart tool – Add Trend Lines to Multiple Series which helps you quickly add trendline for multiple series in a scatter chart with only one click.


Add a trendline for multiple series in Excel

Please do as follows to add a trendline for multiple series in a scatter chart in Excel.

1. Select the scatter chart that you want to add trendline.

shot-add-trendline-to-multiple-series-1

2. Click Kutools > Charts > Chart Tools > Add Trend Lines to Multiple Series.

shot-add-trendline-to-multiple-series-2

3. Click OK in the popping up Kutools for Excel dialog box.

shot-add-trendline-to-multiple-series-3

Now the trendline is added for multiple series in selected scatter chart.

shot-add-trendline-to-multiple-series-4

Notes:

1. This feature does not support Undo (ctrl + z).
2. If you want to remove the added trendline, just select it and press the Delete key.

Productivity Tools Recommended

Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs — no more cluttered windows. Know more...

Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010–2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...


Kutools for Excel

Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 – 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.

🌍 Supports 40+ interface languages
✅ Trusted by 500,000+ users and 80,000+ businesses worldwide
🚀 Compatible with all modern Excel versions
🎁 30-day full-featured trial — no registration, no limitations
Kutools for Excel RibbonKutools for Excel Ribbon