help pls-Calculting numbers then displaying them as textt

[Hijrofoyle]

Hello, I'm doing a frequency distribution graph and am looking to display on the chart the actual values of the intervals, but I don't wanna type them all in manually, is there a way to make the results of a formula appear text box?
i.e. just say that the interval "2" will correspond to the data that lie between data point 1 and 2 which are 1.5 and 3.2 degrees respectively. Now instead of displaying "2" on the x ordinate of the graph, i'd like to display 1.5-3.2 but I do not wish to type it all in manually. I'd imagine that it'd have to be something along the lines of a text box i.e. = "a1-a2" + "-" + "a2-a3"
any ideas?
Thanks in advance.

 

[Andrew Poulsom]

See:

http://j-walk.com/ss/excel/files/charttools.htm

for adding data labels to your chart.