First you need to calculate the label as 1 column, e.g. =TEXT([@Percent], '0%') & ' (' & [@Value] & ')' Then if you don't need to preserve the category, just choose this column as the Axis Label (you can also add category in the above formula). But if you want to separate the axis category from the labels, you will need to do following (steps based on Excel 2010): • insert a Stacked Bar chart, based only on Category and Percent columns • add Data Labels Ntfs for mac os x. >Movie decrypter for mac. > Inside Base for the whole chart • add a 2nd series based on the Label column (via right-click Select Data. > Add, do not change Axis Labels at this stage) - all values will be 0 because it is a text column • delete the original Percent-only labels • right-click on the 0 labels and choose Format Data Series. > Plot Series on Secondary Axis • delete the secondary axis itself that appeared on top of chart • right-click on 0 labels again, Format Data Labels.

Nov 11, 2015 - Adding labels to a stacked column chart in Excel using data, not text boxes. (Note: I'm using the Mac version of Excel 2011 for this tutorial. The two have the value names (30% and 50%) and are entered in those cells via. This does not appear to work, at least not with Excel for Mac. 'Value From Cells' is not an option listed in the Data Label options. The only options given are Series Name, X Value, Y Value, and Bubble Size.

> tick Category Name and untick Value • in Select Data. Dialog, choose the Label series and click Edit Axis Labels (right column) - choose the Label column for the labels Note you can also choose the Percent column as the values of your Label series combined with the Inside End data labels option for the labels to appear at the right-hand side of the bars, but you will need to make sure that both primary and secondary axes are scaled the same.