Chart with number and percentage

In this Excel tutorial you will teach yourself 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. First you need a table data. In this example it is a net worth and its change over last years.
table data

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

clustered column line on secondary axis

You will see chart similar to this.

basic chart template

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

Template

You can download the Template here – Download
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell