Excel Charts - Create a custom data label

[Sunil]

Hi!

I create Metrics on various projects milestones. The output in the bar
graph captures the how many days early or how many days a project is
from it's start date till today. My data is organized on project
numbers on X-axis trended against days early (+ve) or days late( -ve)
on the y-axis. My issue is that I need to present the project
description that corresponds to the project number somewhere in the
chart.

Please provide your valueable assistance.

Regards,
Sunil

 

[Jon Peltier]

Apply a data label to the chart, either as a label on an existing plotted
point, or as a label to a new series added for this purpose. The advantage
of data labels is that they are linked to data points, meaning they are
attached to particular XY coordinates on the chart axes.

The default choices for data label text are rather slim, but you can edit
the text of a label and type your own text. Or you can select the label
(select the pseudo text box, but don't activate the text), type "=" in the
formula bar, and click on a cell, to display the cell's content in the
label.

These two Excel add-ins are free, easy to install, and easy to use, and
perform this last step automatically on single points or on a whole series:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

- Jon