Outside End Data Label for a Column Chart

by Allen Wyatt
(last updated November 21, 2020)

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

Creating Oval Pictures

A couple of ways to create oval shaped pictures in a Word document.

Discover More

Editing Wrap Points

If you have a graphic that has text wrapping around it, you might want a way to modify the wrapping path used by Word. ...

Discover More

Automatically Moving from Cell to Cell when Entering Data

As you enter data in a worksheet, you may want to have Excel automatically move from cell to cell based on the length 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)

Understanding Custom Chart Templates

Excel allows you to create custom chart formats that go beyond the standard formats provided in the program. These custom ...

Discover More

Changing Elements in Lots of Charts at One Time

Got a bunch of charts that you need to make formatting changes in? You can use a macro (or two) to apply the formatting ...

Discover More

Smoothing Out Data Series

One way you can make your charts look more understandable is by removing the "jaggies" that are inherent to line charts. ...

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 seven less than 7?

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.