Skip to main content

Easily create a slope graph in Excel

Author: Siluvia Last Modified: 2024-11-20

Kutools for Excel

Boosts Excel With 300+
Powerful Features

In many cases, you may need to create a slope chart to compare data changes over time by plotting the change between two points only. In Excel, there is no build-in feature to create a slope chart directly. Normally, to create a slope chart in Excel, you need to insert a line with marker chart firstly and then format it with multi-step until it turns to a complete slope chart. Here, I will recommend the Slope Chart utility of Kutools for Excel. With this feature, you can easily create a slope chart with several clicks only.


Easily create a slope graph in Excel

Supposing you want to create a slope chart based on the table data as the below screenshot shown, please do as follows to get it down.

shot-slope-chart-1

1. Click Kutools > Charts > Difference Comparison > Slope Chart.

shot-slope-chart-2

2. In the popping up Slope Chart dialog box, please configure as follows.

2.1) In the Axis Labels box, select the axis values in the table;
2.2) In the Data Series 1 box, select the first series values (this series will display on the left of the slope chart) in the table;
2.3) In the Data Series 2 box, select the second series values (this series will display on the right of the slope chart);
2.4) Click the OK button.

shot-slope-chart-3

Notes:

1. If you want to add data labels to the series, please check the Show values box;
2. Click the Example button to open the slope chart sample.

Now a slope graph is created in current worksheet as the below screenshot shown.

shot-slope-chart-4


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