# How to Show Number and Percentage in Excel Bar Chart

### Method 1 – Use a Helper Column to Show a Number and a Percentage in the Bar Chart

Suppose we have a dataset of some Products, Sales Order, and Total Market Share. Using helper columns, we will show numbers and percentages in an Excel bar chart.

Steps:

• Choose a cell. We have selected cell (F5).
• Enter the following formula.
`=D5*1.15`

• Press Enter.
• Pull the fill handle down to fill the column.

• This sets up the first helper column.

• Copy the following formula into cell G5:
`=D5&CHAR(10)&" ("&TEXT(E5,"0%")&")"`

• Hit the Enter key to get the value.
• Drag the formula down with the fill handle.

• The second helper column is ready.

• Choose the data from the Product and Sales Order columns.

• From the Insert tab, choose 2-D Stacked Column.

• A new bar chart will be created. We will need to edit the chart to show both numbers and percentages inside the chart.

• Right-click on the chart.
• Choose the Select DataÂ option.

• In the Select Data Source dialog, click Add.

• In the Series values section, choose data from the Helper 1Â column.
• Press OK to continue.

• Select the new bars and right-click.
• Choose Format Data Series.

• Click Secondary AxisÂ and your chart will look like the below screenshot.

• Right-click on the new bars again and choose Select Data.

• Add Series 2 and press EditÂ to change it.

• A new window will appear named Axis labels. Select data from the Helper 2Â column and press OK to continue.

• Open the options by right-clicking on the chart.
• Click on Add Data Labels.

• Let’s change the format from the Format Data Labels.

• Check Category Name from the list and choose Inside End to visualize data.

• Your final chart should look like the following image.

Read More:Â How to Make a Percentage Bar Graph in Excel

### Method 2 – Use Format Chart to Show a Number and a Percentage in an Excel Bar Chart

Suppose we have a dataset of Sales in a region over years. We also have some values in percentages. We will show both numbers and percentages in a bar chart.

Steps:

• Select data from the list. We have selected cells (B5:F5).

• While the dataset is selected, choose the 2-D Stacked Column chart from the Insert options.

• A chart will be created.
• Choose the bar from the chart and right-click on it.
• Go to Select Data.

• A new window will appear named Select Data Source. Click Edit in the Horizontal Axis Labels category.

• Choose the years headers from your dataset and press OK. Years will be shown horizontally in the chart.

• Right-click on the bars and choose Add Data LabelsÂ to get the numbers inside the bars.

• Selecting the values on the bars, right-click, and choose Format Data Labels.

• From the right pane, go to Label Options and check Value from cells.

• A new window will appear asking for the range from your table. Choose the percentage values from the dataset and click OK.

• Change the Separator to New lineÂ from the drop-down list to get percentage values just below the numbers.

• Your chart will look like the following screenshot.

• Remove all the unnecessary elements and you will get your final chart.

## Things to Remember

• In the second method, we have shown separating the percentages in a new line. This works in ExcelÂ 2013 or newer. Otherwise, you can use a comma (,) or semicolon (;) to separate them.

## Related Articles

<< Go Back to Excel Bar Chart |Â Excel ChartsÂ |Â Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Wasim Akram

Wasim Akram holds a BSc degree in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Over the past 2 years, he has been actively contributing to the ExcelDemy project, where he has authored more than 150 articles. Now, he is working as an Excel VBA and Content Developer. He likes learning new things about Microsoft Office, especially Excel VBA, Power Query, Data Analysis, and Excel Statistics. He is also very interested in machine learning and... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF