Hi, new to this forum so hello all. Here's my problem, hope you can help. I've got a chart I'm trying to make for a friend and I'd like to add data labels to the chart that are not related to the data the chart corresponds to.
The chart is 3 bars each representing 100% one shade is sales in percentage and the other shade is surplus in percentage. I'd like the data label to show the number of sales/surplus rather than the percentage. Is this possible? Thanks in advance.
Try this free addin which will allow you to link data labels to cells
http://www.appspro.com/Utilities/ChartLabeler.htm
In the cells use formula to construct the information you want displayed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks