Home MS Excel TutorialCharts Chart with number and percentage

Chart with number and percentage

by Easy Excel Tutorials

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


You can download the Template here – Download

You may also like