How to Add Outside End Data Labels in Excel (2 Examples)

We will be using the following dataset where we have some sales and expected sales values for some products.

excel data labels outside end


Example 1 – Using the Outside End Data Labels Option in Excel

This option is only available for Clustered Column charts, Clustered Bar charts and Pie charts.

Using Outside End Data Labels Option in Excel


Case 1.1 – Clustered Column Chart

We will create a Clustered Column chart for the Actual Sales values of the products and then define the position of the data labels.

Outside End Data Labels Option for clustered columns in Excel

  • Select the range.
  • Go to the Insert tab and choose the Insert Column or Bar Chart dropdown.
  • Select the Clustered Column chart option.

  • You will get the following chart.

  • Click on the Chart Elements option.

  • Check the Data Labels option and click on the right-side arrow.
  • Select Outside End.
  • You can see different positions of data labels and choose to change the positions.

  • You will get the data labels at the outside end of the columns.

Outside End Data Labels Option for clustered columns in Excel

Read More: How to Add Data Labels in Excel


Case 1.2 – Clustered Bar Chart

We will form a Clustered Bar chart for the actual sales of the following products and then fix the positions of the data labels outside the bars.

Outside End Data Labels Option for clustered bars in Excel

  • Select the range, and then go to the Insert tab.
  • Select the Insert Column or Bar Chart dropdown and choose the Clustered Bar chart option.

  • Click on Chart Elements.

  • Check the Data Labels button, and click on the right-side
  • Choose the Outside End option among various options.

  • You will be able to move the data labels outside of the Bar chart.

Outside End Data Labels Option for clustered bars in Excel

Read More: How to Edit Data Labels in Excel


Case 1.3 – Pie Chart

We will place the data labels of a Pie chart on the outside end.

Outside End Data Labels Option for pie charts in Excel

  • Select the range, go to the Insert tab, select the Insert Pie or Doughnut Chart dropdown, and choose the 2-D Pie chart option.

  • You will get the following chart.
  • Click on Chart Elements.

chart elements

  • Check the Data Labels button and click to the right arrow.
  • Choose the Outside End option among various options.

  • You will be able to place the data labels on the outside end of the pie chart.

Outside End Data Labels Option for pie charts in Excel

Read More: How to Move Data Labels In Excel Chart


Example 2 – Customizing Data Labels for a Stacked Column Chart to Appear Outside in Excel

We’ll use the same dataset for the Stacked Bar chart.

Customizing Data Labels for Stacked Column Chart to Appear Outside End in Excel

  • Select the range, go to the Insert tab, choose Insert Column or Bar Chart, and select the Stacked Column chart option.

  • You will get the following stacked column chart.

  • Click on the Chart Elements option.
  • Check the Data Labels option and clic on the right arrow.
  • You won’t get the option called Outside End.

  • Add an extra column named Total.
  • Use the following formula in the column.
=C4+D4

formula

  • These three columns will be stacked as three series in the following chart.

Customizing Data Labels for Stacked Column Chart to Appear Outside End in Excel

  • Select the Total series and right-click.

  • Choose the Change Series Chart Type.

  • You will get the Change Chart Type dialog box.
  • Change the Chart Type of the Total series to a Line chart.
  • Press OK.

change chart type

  • You will notice a difference in the Total series.
  • Select this series and go to the Chart Elements, then to Data Labels and Above.

Customizing Data Labels for Stacked Column Chart to Appear Outside End in Excel

  • The data labels will appear outside the columns.

  • Select the line chart and right-click on it.
  • Choose Format Data Series.

  • The Format Data Series window will appear on the right pane.
  • Go to the Fill & Line tab and expand the Line tab, then choose No Line.

format data series

  • We will have the labels outside of the stacked columns.

Customizing Data Labels for Stacked Column Chart to Appear Outside End in Excel

Read More: How to Format Data Labels in Excel


How to Remove Outside End Data Labels in Excel

You can also remove the data labels from your chart if the labels consume extra space in your chart.

Remove Outside End Data Labels in Excel

  • Select the labels and press the Delete key.

  • You will get the following chart without data labels.

Remove Outside End Data Labels in Excel

Read More: How to Remove Zero Data Labels in Excel Graph


Practice Section

We have created a Practice section on the right side of each sheet.

practice


Download the Practice Workbook


Related Articles


<< Go Back To Data Labels in ExcelExcel Chart Elements | Excel Charts | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Tanjima Hossain
Tanjima Hossain

TANJIMA HOSSAIN is a marine engineer who enjoys working with Excel and VBA programming. For her, programming is a handy, time-saving tool for managing data, files, and online tasks. She's skilled in Rhino3D, Maxsurf C++, MS Office, AutoCAD, and Excel & VBA, going beyond the basics. She holds a B.Sc. in Naval Architecture & Marine Engineering from BUET and is now a content developer. In this role, she creates tech-focused content centred around Excel and VBA. Apart from... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo