Referencing a cell value on a chart

[Jason]

I am trying to reference a cell value on a sheet. As this
total changes I want that to be reflected on the chart.
This cell has a function that totals a column of costs to
give me a total cost. I created a graph that shows the
individual columns but I want there to be a total cost
figure on that sheet. Does anyone know how to reference
that cell value on the cost chart?

 

[Debra Dalgleish]

If you want the text from a cell to appear in the chart:

Select the chart
Type an equal sign
Click on the cell that contains the Total Cost
Press the Enter key

A text box will appear near the centre of the chart. Drag it to the
location you want it, and use the buttons on the formatting toolbar to
change the font, size, etc.