Outside End Data Label for a Column Chart

Written by Allen Wyatt (last updated November 21, 2020)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 365


2

When Rod tries to add data labels to a column chart (Chart Design | Add Chart Element [in the Chart Layouts group] | Data Labels in newer versions of Excel or Chart Tools | Layout | Data Labels in older versions of Excel) the options displayed are None, Center, Inside End, and Inside Base. The option he wants is Outside End.

In doing some testing, it appears that what Rod may actually be working with is a stacked column chart and not a normal column chart. The reason I say this is that we could only replicate the problem if the chart type was stacked column; if it was a normal column chart, then the Outside End option was available, as expected.

If it is indeed the case that Rod is using a stacked column chart, then it makes sense that Excel wouldn't offer Outside End as that option wouldn't make a lot of sense—where would one expect Excel to display the labels for more than a single data series if the series are stacked into single columns?

If Rod double-checks and finds that the problem is really with column (not stacked) charts, then it could be that there is a problem with the workbook in which the charts are being created. This can be confirmed by creating a new workbook from scratch (not by copying data or worksheets) and then creating a column chart in that workbook. If the Outside End option is there—as it should be for a column chart—then you'll have a good indicator that the problem is with the other workbook itself.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (12608) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 365.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Rounding by Powers of 10

Need to round a value by a power of 10? You can do it by using the ROUND function as described in this tip.

Discover More

Stepping through Sentences

Need to select an entire sentence at once? You can do so by creating a short macro that does the task for you, or you can ...

Discover More

Changing Orientations within a Single Printout

Excel allows you to print out information in either portrait or landscape orientation, but what if you need both types of ...

Discover More

Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!

More ExcelTips (ribbon)

Changing Y-Axis Label Width

Excel provides quite a bit of flexibility in how your chart looks. One of the least flexible places is in adjusting the ...

Discover More

Changing Text in Text Boxes on a Chart

Macros allow you to make changes to virtually anything you can see in Excel. This tip examines how to make changes (even ...

Discover More

Creating a Log/Log Chart

If you need to create a chart that uses logarithmic values on both axes, it can be confusing how to get what you want. ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] (all 7 characters, in the sequence shown) in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is five less than 6?

2021-05-10 10:09:30

Doris Mearig

(see Figure 1 below)
I have a bar chart that does not allow me to add a data label for a specific bar on the chart. That bar shows an extended boundary outline and although I can change the data label position/alignment for the chart, it does not apply the change to this specific category. I am sure there is a simple explanation but I can't determine how to eliminate that extended boundary that extends beyond the chart area.

Figure 1. Bar chart with missing data label


2021-04-06 11:07:16

scott

i just wanted to say that I have been trying to solve this problem for the last 2 days. I could never figure out why some bar charts had data values in the line and some at the end. You were correct, it was the style of bar chart the system was choosing for me. 1 with it inline and another with data label at end. THANK YOU!


This Site

Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.