Create a bar chart with percentage difference arrow in Excel

Sometimes, while comparing two groups of data, you need to not only list the data as bars in the chart, but also want to display the percentage difference between two data. However, the common bar chart in Excel cannot support but the Difference Arrow Chart of Kutools for Excel can.

shot difference arrow chart 6

Applying this utility by clicking Kutools > Charts > Difference Comparison > Difference Arrow Chart.
shot difference arrow chart 2

1. Enable the sheet that you want to create and insert a difference arrow chart, then click Kutools > Charts > Difference Comparison > Difference Arrow Chart.

2. In the Difference Arrow Chart dialog, firstly, select a chart type you want to create, then go to click shot selectbuttons to separately select the data cells into the Select Data section.
shot difference arrow chart 3

3. Click Ok, a dialog pops out to remind you there will be a hidden sheet created at the same time for placing the calculated data. click Yes to continue.
shot difference arrow chart 4

Then the difference arrow chart has been created.

Bar chart
shot difference arrow chart 5

Column chart
shot difference arrow chart 6

Tips:

1. You can click Example button in the Difference Arrow Chart dialog to realize how to use this utility.

2. The chart changes as the data changes.

3. If you want to change the bar or column color, choose one bar or column, then go to click the Format tab, choose one color as you need in the Shape Fill drop-down menu.
shot difference arrow chart 7


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.

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.