Placing labels on data points in a stacked bar chart in Excel
Solution 1
In playing with Excel, it looks like you can right-click on the dataset and select "Add Data Label." I'm not sure how to replicate what you have exactly.
Solution 2
Check out XY Chart Labeler. It's an excel add-in and contrary to it's name, it supports many chart types.
Don't thank me, User Toc posted this answer in the question you referenced.
Related videos on Youtube
David Yates
I'm a hobbyist programmer, part-time sysadmin, and full-time analytics, big data, data center management, automation, and cloud computing architect and delivery engineer.
Updated on September 17, 2022Comments
-
David Yates over 1 year
Is it possible to place the labels not on the Y axis, but on the data point itself in a stacked bar chart in excel?
I am trying to modify the timeline template available here so that my labels for each bar appear over or next to the bar rather than all the way on the left side.
See the image below for how it looks now.
-
David Yates over 13 yearssuperuser.com/questions/194041/excel-scatter-chart-with-labels/… points to a similar issue, but for XY plots in specific
-
-
David Yates over 13 yearsI saw "XY Chart Labeler" from that other question ... even referenced it in the comment I left on the question :) ..however, it seems to only support scatter plots (from what I read about it)
-
David Yates over 13 yearswow. Thanks Chris. /me goes and hangs head in the corner for not seeing the right-click option!
-
David Yates over 13 yearsI'd still like to be able to put the names on the bars, in addition to the data labels, but this is a good start :)
-
DaveParillo over 13 yearsIt will do bars & columns, but Chris's answer is still better!
-
David Yates over 13 yearsthis is very close to what I'm looking for, and is a great start towards my final goal :)