Chart with number and percentage

In this Excel charting tutorial leasson, you will learn how to create a chart with number and percentage. You will need it to show both numbers and part of a whole or change using percentage.

How to add number and percentage in chart

First you need a table of data. It is a net worth and its change over last years in this example.

percentage chart table data

How to create a chart with both percentage and value

Next, go to the ribbon and select the Insert tab. Click the Insert Combo Chart button. Choose the second one (Clustered Column chart – Line on Secondary Axis).

clustered column line on secondary axis

You will see a percentage chart similar to this.

percentage chart template

How to add a percentage to a number

You should do some formatting:

  • format data as currency and percentage
  • set years to horizontal data labels
  • change chart title
  • add data labels
  • set min and max axes values
  • change colors

Your final chart with number and percentage should look like this:

Chart with number and percentage

You can also customize the chart further by changing the colors, styles, and labels as needed.

See also  Chart that Ignore N/A! Errors and Blank Cells