How to show cell comments on the chart?

Hi chart experts,
Enclosed file includes a sample chart.
Enclosed file includes some comments in the some cells.

So, is it possible to show cell comments on the chart?

Best wishes...

Yes, you can.

review/Comments/Show all comments.

Hi Glenn Kennedy,
I need to see comments on the chart.
Any idea about that?

Here's one way:

First add data labels to the chart (Layout Ribbon > Data Labels)

Define the new data label values in a bunch of cells, like this:

Now, click on any data label. This will select “all” data labels. Now click once again. At this point excel will select only one data label.

Go to Formula bar, press = and point to the cell where the data label for that chart data point is defined.

Repeat the process for all other data labels, one after another.

Tedious if you have a lot to do.

However, there's a great (free) add-in that makes the process soooo easy.

http://www.appspro.com/Utilities/ChartLabeler.htm

Hi Glenn Kennedy,
1- As far as I understand your solution is regarding to delete original series labels and replace them with new data labels.
So, do you have any idea how to put original series labels and new data labels together?
2- As far as I understand your solution is regarding texts in the cell not in the cell comments.
So, do you have any idea how to put cell comments?
Regards.

It may be possible to put cell comments into the cart, directly from the comments box, but that would require VBA (If it's possible at all..). I was suggesting a work around.

Yeah, I need a vba code for this...