Easily create a slope graph in Excel

Kutools for Excel

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.

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

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.

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.

Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2019, 2016, 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013, 2016, 2019 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

The functionality described above is just one of 300 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.