Hi,

In the spreadsheet set up a formula that returns the amount you want. We
don't know anything about your data layout, so lets suppose the formula is in
C2, what ever that formula is.

1. Select the chart.
2. Click the Formula Bar and type = (the equal sign)
3. Click on the cell with the formula, here C2.
4. Press Enter.
5. Drag the text box that was just created anywhere you want on the chart.

Suppose the formula were something like =SUM(A2:A13), you could modify it to
read
="YTD Total: "&C2
this would show on the chart as YTD Total: 123.45 or something similar.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Catherine" wrote:

I have a stacked column chart with data for each month of the year. This
chart is updated monthly. I want to add to the side of the chart a YTD total
that will get automatically updated monthly. Does anyone know how to do this?
Thank you.