Hi, I am trying to to add multiple data labels to a bar chart. I am able to add one data label by selecting "Value From Cells" however, I want to add two sets of data labels from two columns. So that I will have to data labels on top of the bars.
Hi, I am trying to to add multiple data labels to a bar chart. I am able to add one data label by selecting "Value From Cells" however, I want to add two sets of data labels from two columns. So that I will have to data labels on top of the bars.
Use a extra data series.
Same values but data labels from different location with different position (outside end).
Change the Overlap value to 100%
thanks for that. I should have been more clear, i wanted to add two data labels from two different columns (not associated with the range value). in your example, i want to place "Center label Text" and "Top label Text" on top of the bars, not the data values.
i figured it out using your example! thanks for your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks